Forum Discussion
Rank table of Percentage from another table.
Hello, I want to rank lists of percentages that include ("N/A", Negative and Positive % Values), based on the highest percentage that has to be 1st and lowest percentage (till highest negative perce...
Enter the following into J2, then copy into J2:O24 and format as General:
=IF(ISNUMBER(B2), RANK(B2, B$2:B$24), "N/A")