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")
Thank you so much JoeUser2004 !
Formula works perfectly but I guess symbols and ranks are not well synced in table 2, Filters are not working properly in Table2
The result of filter sorting is not well synced to each other. When I sort in Table 1, it is well synced in Table 2 but when I use the filter in Table 2 to sort the rank from smallest to largest, filters seem to be not functioning, and ranks are not synced with symbols.
- You would need to use Copy>Paste Special Values before sorting Table 2.
