LinkBack URL
About LinkBacks
Please see the attached sample worksheet. I am attempting to combine 2 lists of names and then sort the new list alphabetically (formula only - no vba code).
Thanks in advance for your help.
Please see the attached sample worksheet. I am attempting to combine 2 lists of names and then sort the new list alphabetically (formula only - no vba code).
Thanks in advance for your help.
Hey CRJ,
Why don't you simply copy the second list under the first list and sort them in a single list. No VBA needed. You will need about 6 mouse clicks to accomplish the task.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
The individuals that will be using this workbook are not computer savvy...they just want a single list in "drop-down" form. The problem seems to stem from the combined list of name that was derived via formula. If the combined list was "hand entered" there would not be a problem (in the past the technique I used in the attached sample worked perfectly - except names were hand entered).
It looks like Kultools has a method but I still think it involves some VBA. I'd teach the end user how to copy and paste.
https://www.extendoffice.com/documen...-one-list.html
Marvin...thanks - both options in the above would be fine; however, I wish to stay away from vba code, and since I have 6+users, I can't justify the cost of Kultools... we are a volunteer organization - simple tasks move from "person to person" on a regular basis, so training is out of the question.
Hi CRJ,
If there is a formula to do this with different length lists, I don't know how to do it. In the latest version of excel there are newer functions of Unique() and Sort() that might help but I expect your group doesn't have those either. Perhaps one of the smart Guru's will know how to solve this problem.
Good luck. I hope there is an answer with your constraints.
Try in E9:
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Please Login or Register to view this content.
F9:G9:Please Login or Register to view this content.
Please Login or Register to view this content.
Quang PT
Works perfectly...thanks so much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks