Hello everyone,
For a couple of days now I have been struggling to find out how I match the name of the corresponding nth largest value in Excel.
In this hypothetical example (look in the uploaded file), I am trying to find the top 3 largest values within a date range (February 2019). This works just fine.
However, once I try to lookup the name of the product or the person that is selling the product, I can't seem to retreive the correct row number, and when I am dealing with duplicates it will only show me the first variable that it finds, not the second or third one.
I hope my explanation and the hypothetical example that I uploaded provides enough information about my problem, if not please ask for additional info.
Kind regards,
Hoogoo
PS: I am not able to upload my .xls file for some reason, so here is a picture
Excel Hypothetical 1.png
Bookmarks