Allocate a number to Ranges of numbers|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I need to allocate a sequential number to sets of numbers as follows:

Suppose A1 to A24 contain the consecutive numbers 1 to 24.

In Col B I need to allocate an integer to each number within consecutive groups of eight numbers, so that each number in Col A from 1 to 8 is allocated the number 1, each number from 9 to 18 is allocated the number 2, etc.

See the attached example sheet.

What formula do I need in B1 to copy down?

I've tried various combos of quotient, roundup and ceiling but can't get it to work properly, especially at the boundaries.

Thanks!