Find and sum duplicate value then sort by Top 10

[sneakyla]

Hello!

I was wondering if anyone can help me find the right formula for what I'm trying to achieve.

I have a large data with multiple sales from different customers and need a formula to automatically sum the total unit of the same item (duplicates) then have it sorted from top 10 (LARGE formula).

For example.

apple	3​			Top 10 Selling Items
orange	1​		1​
pineapple	2​		2​
banana	3​		3​
apple	54​		4​
apple	1​		5​
apple	2​		6​
orange	3​		7​
pineapple	1​		8​
banana	1​		9​
			10​

Thank you!!

 

[Legacy 143009]

In this case using a Pivot Table would be the best practice.
Select your data. Go to insert tab and click Pivot table.
Select a place where to place your table. It can be either in the same sheet or a separate sheet.
After inserting, you will see some sections on the bottom right. Drag your Products to rows section. and your sales to values section.
Sort the total values in descending order.