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 percentage) last, if the value is "N/A" return "N/A". The rank should relate to the symbol.
I want something like this
https://filebin.net/m5gwi0emb2pyf1f6
5 Replies
RohitJung In Cell K2, the formula
=IFERROR(RANK(Table7[@[8/12/2021]],Table7[8/12/2021],0),"N/A")
was inserted and copied across and down to produce the result shown below
Hello, Doug_Robbins_Word_MVP thankyou so much for the reply.
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.
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.
