Hi,
Its me again. I am trying to get a sumproduct ranking without any duplicates.
=IF(J24="","",SUMPRODUCT((I24=$I$6:$I$1500)*(B24<$B$6:$B$1500))+1)
At the moment I am only getting Dupplicate rank should they match. How can I go about getting this changed to the next rank number. If I am able to get it in sequenctial order then I am able to create a table that shows me my top sold menu items for each catagory.
Assuming R19=12, I am not able to get the item for this since i have two products that are ranked 11 hencefourth skipping 12. I found some solutions but this is just pure countif.
=INDEX($A$6:$K$600, SMALL(IF(COUNTIF($S$7, $I$6:$I$600)*COUNTIF(R19, $K$6:$K$600), MATCH(ROW($A$6:$H$600),ROW($A$6:$H$600))), ROWS($A$1:A1)), COLUMNS($A$1:$A$1))
Regards,
Mustafa
Bookmarks