Hi,
I have an excel sheet where I require to sort the data with country and level. The sorting should be done in following order.
I have attached the excel sheet for your reference.
Country Level
US Complete
UK Complete
CAN Complete
AU Complete
US Advisory
UK Advisory
CAN Advisory
AU Advisory
US Exchange
UK Exchange
CAN Exchange
AU Exchange
Not Available
Thanks in advance for your help.
KaminaBook2.xlsx
You can to do it by edit custom list
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
with VLookup to determine the status
sort small to great
country Z to A
number small to great
You expect a differant result in Not Available, but I think that will be a mistake.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
This works
Copy columns A B and C to Sheet2
in
Sheet2!D1
=LOOKUP(C1,{"Advisory","Complete","Exchange","Not Available"},{2,1,3,4})&LOOKUP(LEFT(B1,FIND(" ",B1)),{"Australia","Canada","UK","US"},{4,3,2,1})
and copy down
Sort by column D
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks