ExcelBanter - Sort help please

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sort help please (https://www.excelbanter.com/excel-programming/419571-sort-help-please.html)

Yossy

Sort help please

How can I sort all these using Country. PLease all help totally appreciated.
Where no country they should all line up below one another

ABS
ABS_Canada
GBP_JKL_Spain
DCG_Netherland
HNK_France
HGP_Ontario
KLG_France
JKL_Canada
KLMN_PLH_MMM_Spain
DCG_GPK_Ontario
GBH
GHN
MNL_LOFG_MMMM_Netherland

Thanks

Mike H

Sort help please

You have an answer in your other thread plaease don't multipost it's
irritating for those who give their time freely to answer questions only to
find it answered in another thread.

"Yossy" wrote:

How can I sort all these using Country. PLease all help totally appreciated.
Where no country they should all line up below one another

ABS
ABS_Canada
GBP_JKL_Spain
DCG_Netherland
HNK_France
HGP_Ontario
KLG_France
JKL_Canada
KLMN_PLH_MMM_Spain
DCG_GPK_Ontario
GBH
GHN
MNL_LOFG_MMMM_Netherland

Thanks

All times are GMT +1. The time now is 10:30 PM.