Excel:Sorting2

Closed
Somerandomdude - Oct 4, 2011 at 06:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2011 at 08:43 PM
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


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 6, 2011 at 08:43 PM
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)
0