Top 5 selling items

[pdhawan]

Hi

Is there a way to find out the top 5 selling items in the attached file.

Thanks

[Teethless mama]

Try Auto Filter > Select top 10 and change it to top 5

[pdhawan]

Thanks heaps

[Teethless mama]

You're Welcome!

[Fotis1991]

And of course if you need these in a separate table OR in another worksheet, you can use formulas to get the expected result.