Excel:Sorting

Closed
Somerandomdude - Oct 4, 2011 at 06:39 AM
 Blocked Profile - Oct 4, 2011 at 06:41 AM
Hello,
I have 2 columns with country names
i need to find which country is most used and sort it DESC 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
Germany
Belarus Germany
Germany
Poland
Belarus Germany
Greece Greece
Bulgaria Greece
Romania Greece
Bdestination Rdestination



//as u can see Germany without B destination is most commonly used,after goes Belarus-Germany,all others only repeat 1 time//

should be like this:
E1 F1
Bdestination Rdestination
Germany
Germany
Belarus Germany
Belarus Germany
Bulgaria Greece
Greece Greece
Romania Greece
Poland
Bdestination Rdestination

Related:

1 response

Blocked Profile
Oct 4, 2011 at 06:41 AM
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0