Excel:Sorting2

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
Would be very thankful if You could help.
I have 2 columns with country names
i need to find which country is most used and sort it DESC by quantity and by A-Z
(most common used countries are more important and go top)
and also i need to ignore(stay in place) rows that have "destination" in them as it counts this as country.
example:
E1 F1
Bdestination Rdestination
(empty space) Germany
Belarus Germany
(empty space) Germany
(empty space) Poland
Belarus Germany
Greece Greece
Bulgaria Greece
Romania Greece
Bdestination Rdestination



//as You can see Germany without B destination is most commonly used, also Belarus-Germany repeats 2 times,all others only repeat 1 time//

should be like this:
E1 F1
Bdestination Rdestination
(empty space) Germany
(empty space) Germany
Belarus Germany
Belarus Germany
Bulgaria Greece
Greece Greece
Romania Greece
(empty space) Poland
Bdestination Rdestination

Please excuse my bad english , it is not my native language/didnt learn it at school either.
Thank you for Your help regardless, Somerandomdude


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
The way i see the solution is

1. in one column have the the current row number of each row (you can use =ROW() and then use copy and paste to convert to values. You must have value and not formula here)

2. in the other column have a count of each country (you can use countif)

3. sort on the countif column

4. now you you have to cut and paste each row where it was destination (ROW number will tell you which row to paste at)