Excel: need to identify unique values across two sheets with multiple columns, need help ASAP please

affyfiler

New Member
Joined
Apr 20, 2017
Messages
1
Hi, I was hoping to find a way to identify unique values across two sheets in excel. However I want to do this with four columns grouped together, so it would compare four columns in sheet 1 against four columns in sheet 2 to discover if it is a unique value within the entirety of the list. This is because one of the lists in sheet 2 had rows removed from it, and some of the names in one of the columns have been changed based on new information, therefore I need to identify which ones these are in the original list (sheet 1). Hope that makes sense!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
loop through each set of data and if a match is found move on if no match label row in first group unique
 
Upvote 0

Forum statistics

Threads
1,216,030
Messages
6,128,418
Members
449,449
Latest member
Quiet_Nectarine_

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top