I have a problem with ranking of data.

I have 4,300 cells populated with data. This data has been sorted and now I need to rank the data in 1% increments. For example, the first 1% of data (43 cells) will be ranked #1, the second 1% of data will be ranked #2 etc. How can I automate this process? I tried playing around with the "Rank" command but that did not seem to work.


Thanks so much