John Darby
asked on
4 columns compared for uniqueness
Greetings,
I have 4 columns and am trying to compare each column to assure no names are repeated. The actual columns in question are about 30000 entries in-length. I shortened it here for ease of viewing. Could you suggest an approach to compare these four columns? I was having a challenge trying VLOOKUP.
Thank you!
JohnD
pairwise-comparisons.xlsx
I have 4 columns and am trying to compare each column to assure no names are repeated. The actual columns in question are about 30000 entries in-length. I shortened it here for ease of viewing. Could you suggest an approach to compare these four columns? I was having a challenge trying VLOOKUP.
Thank you!
JohnD
pairwise-comparisons.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you
including these two new ones.
Creating your own Excel Formulas and doing the impossible
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you
including these two new ones.
Creating your own Excel Formulas and doing the impossible
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
Glad to also be of help.
ASKER