Hi all, i am using the following formula Sumproduct(($a$2:a$10702=a2)*($c2:$c$10702>c2))+1
Column A is the groups and Column C is the $ sales that i want ranked within these groups. I am doing an index match function to pull the customer (column B) on anther sheet by rank, but it returns blank for 3rd place when two customers are tied for 2nd.
Thanks all, any help on this would be appreciated.
Bookmarks