1st most common products sold, 2nd, ....10th

Originally Posted by jameel30

Rob, thanks for the reply, but both of your formulas are the same exact thing.

Probably because I accidentally pasted the same formula twice. Oops.

Try this in C2:

="No. "&ROW()-1&" seller is: "&INDEX($A$2:$B$100,MATCH(LARGE($B$2:$B$100,ROW()-1),$B$2:$B$100,0),1)