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...
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.