• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Microsoft Excel question - finding the intersection of two lists

P

PremiumG

Platinum Member
Excel experts, I have a 2 lists of names separated into four columns.

First name, last name and the first name, last name.

How can I make a list of names that both sets have in common? (the intersection of the two sets)? I heard this is possible without database programs and in Excel.
 
I'm not sure how well it will work, but you might want to use the concatenate function to merge the two sets of names into two columns, then use one of the lookup functions to run a comparison (I think VLOOKUP will work for this, but it's been a while since I used it.)
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top