Thread: Extracting Top 5 or 10 from a list

Hi All,

This has been intriguing me for some time now.

How do I extract a data from an array of data, condition being Top 5 or 10 in a list.

E.g in the attached sheet, which is the sale price listing of a Retail Store, I want to know the Top 10 discounted items (Column F) for every change in Sub Group (Column B).

Appreciate all the help!!

Originally Posted by Andy Pope

You could use a pivot table.

Great help Andy...this works for me.

Cheers!

Originally Posted by BlueWhale

This link can be useful for you.

http://www.exceldigest.com/myblog/20...ms-in-a-range/

Great help ...this works for me.

Cheers!