quickest way to check if any values are not in the second subset

yxz152830

Active Member
Joined
Oct 6, 2021
Messages
393
Office Version
  1. 365
Platform
  1. Windows
Gurus,
what is the simplest and fastest way to check if 2 columns have their own unique values, meaning they might be duplicates in respective column but do not exist in the other column? Conditional formatting does not work in my case because of duplicates in each column.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Please give specific sample via: screenshot/image/SL2BB
it's something like : 3 is unique to the 2nd column but a duplicate in the 1st column and the conditional formatting would not be able to differentiate the value from the rest. I wanna filter out all the values which are unique to the contrast but may or may not be duplicates in their own columns.


97​
162​
87​
197​
33​
151​
56​
107​
64​
129​
3​
181​
31​
136​
23​
110​
47​
117​
75​
157​
90​
200​
25​
101​
44​
182​
24​
153​
61​
142​
64​
153​
80​
192​
16​
193​
24​
149​
57​
120​
78​
103​
59​
109​
3​
192​
35​
133​
158​
102​
179​
131​
139​
185​
186​
111​
 
Upvote 0

Forum statistics

Threads
1,215,497
Messages
6,125,157
Members
449,208
Latest member
emmac

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