On 2002-08-29 15:11, Garrett wrote:
How do you rank values in a table in descending order? For instance the lower the number the higher the ranking.
On 2002-08-30 09:53, Garrett wrote:
Thanks for your help! Your solution helped me out but posed me w/another problem.
In my excel spreadsheet, I have 4 ranking columns. 2 need to rank in ascending order and 2 need to rank in descending order.
When I added the ,1 to my formula and dragged it down to all 34 cells, it gave me a gap between the #1 rank and the #2 rank. Instead it jumped from #1 to #34. Can you help w/this?