Excel:Sorting2 Closed

Question

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


Configuration: Windows XP / Firefox 7.0

rizvisa1 · Answer

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)

Excel:Sorting2

1 response

Similar discussions

Subscribe To Our Newsletter!