Filtering Top 10 Results Based on 2nd Column

[newbieexceldude]

Hi all,

I trying to do this without a long drawn out process in pivot tables.

Column B has a list of records (Products) and Column C has the metrics for B (Number of Products sold).

I want to filter/extract the Top 10 sales for each product. In other words, B will have the top 10 values in C.

I'm trying to see if there is a formula or function that would work her. I watched a video on the LARGE function but couldn't quite follow.

All help will be appreciated. Thanks.

[Tony Valko]

This shows how to do a top 3. Maybe you can tweak it for a top 10.

http://www.excelforum.com/showthread.php?p=3639972

[newbieexceldude]

Not having any luck with this, so far. But thanks for trying to help.

[newbieexceldude]

Does anyone think this would be easier with a macro?