Hi,
For Excel 2007:
I need a formula (maybe 2 if needed) to list top 10 products sold.
I have over 100 different products listed in Col A, copies sold in Col B.

I would like 2 new columns output (Col C, Col D):
Under Col C, 10 values:
No. 1 seller is: (This is the most common product sold)
No. 2 seller is: (This is the 2nd most common product sold)
No. 3 seller is:
..
..
Under Col D, 10 values:
Copies sold from No. 1 seller:
Copies sold from No. 2 seller:
..
..

Thank you