This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Hi - I'm trying to return the top 5 bestsellers based off multiple criteria. At the moment I've tried to simplify it to just return the top result, following that (hopeful) success I can adapt to get the 2nd, 3rd, 4th & 5th items
I need to return the sku number, from that I can return the rest off of the info easily. The result will change based off of 4 different criteria - metric, Country, Category and Link.
This is the formula as it stands -
=INDEX(Data!$D:$D,MATCH(MAXifs(index(Data!G:J,,match($W$5,Data!$G$1:$J$1,0)),Data!$A:$A,$W$6,Data!$F:$F,$W$7,Data!$C:$C,"*"&$W$8&"*"),index(Data!G:J,,match($W$5,Data!$G$1:$J$1,0))))
Here's the link to my data set and the table showing the criteria - https://imgur.com/a/UT9fx5H
I'm honestly a bit stumped, I can't work out where it's going wrong or why it's returning a sku number that has no relevance to the criteria.
I also think I'm potentially going to have a problem in that if the match criteria is just a number it could return the wrong sku number, but I'm not sure how to get around this. Quite possibly I'm going at this from the wrong angle so I'm open to any suggestions however I can't use VBA.
Post Details
- Posted
- 2 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...