A
Adam1 Chicago
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
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