Hello everyone,
I am trying to filter out some data by product, country, and rank # (e.g the largest,second largest). The problem I am getting is that I am not able to figure out how to sort the largest number.
So, when there are multiple countries with the same product #, the following function selects the first column instead of the largest number given those conditions.
={LARGE(INDEX(B3:E7,MATCH(1,(B3:B7=I3)*($C$3:$C$7=I4),0),4),I5)}
I think the large function is misplaced. I have attached an image of the excel as I am not able to upload the file.
Thanks!
Capture.PNG
Bookmarks