I have a list of over 350 numbers in a range. I would like to take the top 50 highest numbers and assign them the value "7", then the next 50 "6", and so on down to the lowest 50 being assigned "1".
These values do change on a quarterly basis. The overall spreadsheet is sorted in various other ways as well, so I can't rely solely on the rankings.
I feel like this is doable but I'm simply not figuring out a way to make this happen. Thanks for any help or advice.
Bookmarks