How do I divide a data set into a specified number of groups

[jstanley41]

I have a data set with 1811 people (each row represents one person). How do I create a new variable that divides the 1811 people into 10 groups sequentially? For example the first 181 individuals are assigned a "1", the next 181 individuals are assigned a "2", and so on until the 10th group consists of 181 people + the remainder?

[FDibbins]

with your data in column A, in B1 enter 1, then in B2, copied down, use this....

=IF(MOD(ROW(),10)=0,B1+1,B1)

[jstanley41]

Thanks, I got it!