Sort Formula on different categories

[mayoub]

Hi Guys,

I have the following sheet (the actual one includes 1000 line in it),
How can i use a sort formula to actually sort in a descending way for each category (i.e: Cars, Bikes...)

Thanks.

Item	Sales
Cars	42
BMW	12
Mercedes	3
Renault	9
Citroen	18
Bikes	24
BMW	7
Suzuki	15
Ferrari	2
Bicycles	203
BMX	23
Hites	19
Jet	125
Bondel	36

<tbody>
</tbody>

 

[shg]

Put the categories in a separate column, then sort:

	A​	B​	C​
1​		Item​	Sales​
2​	Bicycles	BMX	23​
3​	Bicycles	Bondel	36​
4​	Bicycles	Hites	19​
5​	Bicycles	Jet	125​
6​	Bikes	BMW	7​
7​	Bikes	Ferrari	2​
8​	Bikes	Suzuki	15​
9​	Cars	BMW	12​
10​	Cars	Citroen	18​
11​	Cars	Mercedes	3​
12​	Cars	Renault	9​