User Profile
neny2000
Copper Contributor
Joined Feb 09, 2023
User Widgets
Recent Discussions
Why does this Index Match Work
INDEX('last week sales'!U:U,MATCH(1,('last week sales'!W:W=LARGE('last week sales'!W:W,B128))*(COUNTIF($C$127:C127,'last week sales'!U:U)=0),0)) Where U is a list of products and W is the sales for each product. This formula WORKS and gives a ranked list of SKUs from largest to smallest with no duplicates (like if there's two SKUs with the same amount of sales, it gives me each SKU, not the same SKU twice). C127 is where my output starts (header) B128 is where I have my ranking, ie. 1 being the 1st largest number in the data set and so on. This formula works perfectly, but like I don't understand why or how it works. Please provide an explanation so I can use it for other purposes. What does each component do?1.1KViews0likes2Comments
Recent Blog Articles
No content to show