If I have two lists, and in each list there are two columns (first name and last name). How do I pick out names that are unique from both lists. One list contains 10 names, the other list contains 14 names. Both lists can contain the same name. So I want to find unique names from both lists and list them in a new column. I don't want to use conditional formatting, only formula.
Thanks for that. I like the way that you show us how you build the formula, this makes your solution very clear, thank you.
I have a question: How can I find the empty cell in excel sheet? Is there formula for this? thank you
=if(A1="","Empty","")
If I have two lists, and in each list there are two columns (first name and last name). How do I pick out names that are unique from both lists. One list contains 10 names, the other list contains 14 names. Both lists can contain the same name. So I want to find unique names from both lists and list them in a new column.
I don't want to use conditional formatting, only formula.