Trying to find unique values in four columns of data #stumped

[SomethngWicked]

Hi Excel Masters,

I have a perplexing problem that I could use your help with. I have four columns of numerical data in varying lengths on a single worksheet. The unique thing about this data is that no value is identical across all four columns. For example, column A has a value of 200 - and this value may also show up in columns B and C but it cannot exist in column D as that would mean it exists in each of the four columns. Similarly, column B has a value of 204 but that value may not exist at all in columns A, C, or D. I'm wanting to find out which columns are missing this data.

In other words, each column has a unique set of values that may or may not be present in other columns. So for example, I would like to figure out what values are present in columns B, C, and D, that are not present in column A. The tricky thing is some the values in column A are also in columns B, C, and D.

Is such a thing even possible? I've been researching this through several Excel websites and my search has been fruitless.

Thank you!

 

[cerfani]

kinda hard to picture what exactly you are trying to do so this is kinda a wild guess but you can just use match function and if it errors out then it isnt found in the range...

=IFERROR(IF(MATCH(E1,A:A,0)>0,""),"A")&IFERROR(IF(MATCH(E1,B:B,0)>0,""),"B")&IFERROR(IF(MATCH(E1,C:C,0)>0,""),"C")&IFERROR(IF(MATCH(E1,D:D,0)>0,""),"D")

you will get an empty string if the value in E1 is found in all columns or something like "AC" if it is missing from A and C.

 

[SomethngWicked]

Hey cerfani, I was actually just now able to figure this out by simply using Excel's built in 'highlight unique values' function after consolidating my data. Thanks for the response though!