Hi, i have been trying to do up the rank order based on the following conditions.
I managed to rank the sale records of the officers in the same grade ( =COUNTIFS([Grade)],[@[Grade]],[Perf Grade],[@[Perf Grade]],[Sale],">"&[@[Sale]])+1)
However, not able to rank each officer's sale against other officers in the same grade but higher performance grade i.e. The sale record of Kelvin should be ranked with officers with perf grade B. Able to help? Thanks a lot!!
I managed to rank the sale records of the officers in the same grade ( =COUNTIFS([Grade)],[@[Grade]],[Perf Grade],[@[Perf Grade]],[Sale],">"&[@[Sale]])+1)
However, not able to rank each officer's sale against other officers in the same grade but higher performance grade i.e. The sale record of Kelvin should be ranked with officers with perf grade B. Able to help? Thanks a lot!!
| Column A | Column B | Column C | Column D | Column E | Column F |
| Officer | Grade | Perf Grade | Sale | Rank Order | To rank against |
| John | 4 | B | 1000 | 1 | A |
| Alex | 4 | B | 950 | 2 | A |
| Ronald | 4 | B | 800 | 5 | A |
| Kelvin | 4 | C | 900 | 3 | B |
| Tyler | 4 | B | 890 | 4 | A |
| Eren | 4 | A | 1100 | 1 | NA |
