J
Jugglertwo
I haven't been able to figure this one out but a co-worker needs to have a
unique list generated by two lists. We are using Excel 2003.
1) she has two lists. for example:
First List Second List Combined List
Harry Brown * Harry Brown Harry Brown *
Ben Boat * Ben Boat Ben Boat *
Mary Moon * Glen Glue Mary Moon *
Val Value * Will Wish Glen Glue
Val Value *
Will Wish
2) She wants to combine all the names from the First List and the Second
List into the Combined List but she doesn't want any duplicate names.
3) All the First List names have a *.
4) There is no * for the Second List.
5) When the same name appears in the First List and the Second List, she
wants the name to appear with the * like Harry Brown * in the Third List.
6) If the name is not in the First List, she wants the name to appear
without the * like Glen Glue in the Third List.
The only way that I have figured out how to do it involves removing the *
from the First List, then copying the Second List under the First List, then
using the Advanced Filter feature and picking "unique records only."
The problem with my solution is that the * is not on the Combined List and
this is what my co-worker wants.
I hope this isn't too confusing. If anyone would be able to solve this, I
would greatly appreciate it. It has "driven me up a wall."
Thanks!
Jugglertwo
unique list generated by two lists. We are using Excel 2003.
1) she has two lists. for example:
First List Second List Combined List
Harry Brown * Harry Brown Harry Brown *
Ben Boat * Ben Boat Ben Boat *
Mary Moon * Glen Glue Mary Moon *
Val Value * Will Wish Glen Glue
Val Value *
Will Wish
2) She wants to combine all the names from the First List and the Second
List into the Combined List but she doesn't want any duplicate names.
3) All the First List names have a *.
4) There is no * for the Second List.
5) When the same name appears in the First List and the Second List, she
wants the name to appear with the * like Harry Brown * in the Third List.
6) If the name is not in the First List, she wants the name to appear
without the * like Glen Glue in the Third List.
The only way that I have figured out how to do it involves removing the *
from the First List, then copying the Second List under the First List, then
using the Advanced Filter feature and picking "unique records only."
The problem with my solution is that the * is not on the Combined List and
this is what my co-worker wants.
I hope this isn't too confusing. If anyone would be able to solve this, I
would greatly appreciate it. It has "driven me up a wall."
Thanks!
Jugglertwo