Hello,

I would like to sort the data's in a sheet based on the values in a column. And column has 4 values S, M, MI, SI.

First the data should be sorted by the values S, M, MI, SI, like all S first then M, then MI and the SI.

Now only the rows contain S should be filtered and select the next column which has some values and sort the data in filter from largest to smallest.

Then, filter only the rows has M and then sort the data in filter based on next column.

and the same for the rest two (MI and SI) also.

Please help.

thank you.