P
P
powercoder2019-12-09 20:25:26
Parsing
powercoder, 2019-12-09 20:25:26

How to sort a table with a list of the same values ​​in descending order?

There is a column in Excel with duplicate values, I will give an example of them (filtered alphabetically):

Samsung Galaxy A
Samsung Galaxy A
Samsung Galaxy A
Samsung Galaxy A
Samsung Galaxy G
Samsung Galaxy G
Samsung Galaxy G
Samsung Galaxy G
Samsung Galaxy G
Samsung Galaxy G
Samsung Galaxy H
Samsung Galaxy S
Samsung Galaxy S
Samsung Galaxy S
Samsung Galaxy S Pro
Samsung Galaxy S Pro
Samsung Galaxy S Pro
Samsung Galaxy S Pro
Samsung Galaxy S Pro

Further, a large number of goods, this is just an excerpt. Basically the same models for 18 in a row.
How to sort so that they are filtered in descending order of the same values ?
For example, if we take the above example:
(1) Samsung Galaxy G
(2) Samsung Galaxy G
(3) Samsung Galaxy G
(4) Samsung Galaxy G
(5) Samsung Galaxy G
(6) Samsung Galaxy G

(1) Samsung Galaxy S Pro
(2) Samsung Galaxy S Pro
(3) Samsung Galaxy S Pro
(4) Samsung Galaxy S Pro
(5) Samsung Galaxy S Pro

(1) Samsung Galaxy A
(2) Samsung Galaxy A
(3) Samsung Galaxy A
(4) Samsung Galaxy A

(1) Samsung Galaxy S
(2) Samsung Galaxy S
(3) Samsung Galaxy S

(1) Samsung Galaxy H

And at the same time, the filtering should be on this column (A), and the neighboring ones (B, C, D, E ...) should be dependent and change along with it, but fixed in relation to it.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
akelsey, 2019-12-09
@akelsey

5deea629ef48d138035460.gif

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question