Hello,
I'm currently using the following array formulas to return top 10 products with the highest sales for a certain week (such as week 52).
{=INDEX(A:A,MATCH(LARGE(IF(B:B=52,C:C),1),C:C,0))}
{=INDEX(A:A,MATCH(LARGE(IF(B:B=52,C:C),2),C:C,0))}
{=INDEX(A:A,MATCH(LARGE(IF(B:B=52,C:C),3),C:C,0))}
...etc all the way to 10.
I now need to increase the conditions to also match value 1 in column D and 0 in column E (sample data attached). I would understand how to do this with a normal INDEX MATCH formula, but the LARGE function to get the highest sales has thrown me off. Does anyone know how to alter the formula to achieve this?
Any help would be hugely appreciated! Thank you
Bookmarks