I have sales data by location. Each location is managed by a VPO. VPO will manage multiple locations. I need to be able to rank sales by VPO. I know I can sort the sales by VPO, rank the VPO's sales, copy and paste the rank values. The file has to be sorted by location when it is finally sent out.
Is there a formula that will rank sales based on the VPO's name without sorting them first? Attached is an example.
Bookmarks