Segmenting and assigning group numbers

[Guest]

I have a list of 750 ranked names; a column to their left is numbered 1 -
750. In another column I want to assign each name a number representing it's
decile ranking. For example, the first 75 names get a "1", 76-150 get a "2",
etc. I don't want to simply do it manually because the number of names and
the number of segments may change.

How can I get excel to check the name's # and assign the correct decile #?

Thank you

 

[Dave Peterson]

If A1 contained the first number:

=INT((A1-1)/75)+1

And drag down.