Avatar of uad
uad
Flag for United States of America

asked on 

Return a rank based grid data

I am trying on returning the rank of individuals based on the sales in a specific month.  On the attached 1B - E are the ranks, with anything below 4's minimum returning a 5; column A are the months 1-12 and, B2-E13 are the minimum sales necessary for the specific rank.

I am assuming I should be using match, but I seem to be totally stumped on how to approach this.
SalesGrid.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
Martin Andrews

8/22/2022 - Mon