Sort Formula on different categories

mayoub · Jul 23, 2018

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Cars[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]BMW[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Mercedes[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Renault[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Citroen[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]Bikes[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]BMW[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Suzuki[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Ferrari[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Bicycles[/TD]
[TD]203[/TD]
[/TR]
[TR]
[TD]BMX[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Hites[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]Jet[/TD]
[TD]125[/TD]
[/TR]
[TR]
[TD]Bondel[/TD]
[TD]36[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

shg · Jul 23, 2018

Put the categories in a separate column, then sort:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A

[/td][td="bgcolor:#C0C0C0"]

B

[/td][td="bgcolor:#C0C0C0"]

C

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1

[/td][td][/td][td="bgcolor:#F3F3F3"]

Item

[/td][td="bgcolor:#F3F3F3"]

Sales