Hi everyone! My problem is that I easily create a code for each country with the function CONCATENATE linking name and id; however when I want to sort by name of country again, all the data change as well as the code. For instance, if I sort these country by Name, Angola will have the code "AGO3" instead of "AGO2" and United Arab Emirates' id will drop down to the "U" id range. Any idea, pls?!
Ex
Afghanistan AFG 1 AFG1
Angola AGO 2 AGO2
Albania ALB 3 ALB3
United Arab Emirates ARE 4 ARE4
Can you attach an Excel sheet? It's not possible to tell what is in each cell from your example...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Attached
Everything sorts perfectly on the sheet you posted....
Yes but I don't know why it doesn't work in the file where I'm actually working. However, I'm pasting the columns again on my working-file and it's working. Thanks for the easy hint xD
Glad to have helped... if I did!!!! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks