Compare Column B,C & D with Column A and display in Column F

[MeeshR]

Hello,

I have a spreadsheet with 4 columns. I want to know if any of the values in Column A - DO NOT APPEAR - in the either one of the other 3. And if there are some, I would like them to be displayed in Column F.

*I know I can use Conditional Formatting to get those values highlighted but I would rather get a list of the values without having to scroll through the 488 values to find highlighted ones.. *

"I would like the formula to spit out the result in Column F."

Thank you!!

 

[Monty]

Hello MeeshR

Can i have sample file please.

 

[MeeshR]

Here you go, Thank you!

 

[Monty]

Meesh.

Running out of time...could you please check the below link may be helpful..
https://fiveminutelessons.com/learn...-duplicate-rows-excel-across-multiple-columns

Please let me know any challenges..

 

[MeeshR]

Thank you, I am not finding what I need from that article.

Can someone else help?

 

[bosco_yip]

Thank you, I am not finding what I need from that article.

Can someone else help?

Please check attachment with helper column added

Regards

 

[MeeshR]

Thank you!

Is there a formula to check if the there are values duplicated in Column B, C or D?

for example, value is in column B and also in column D
or value is in column C and also in column D

Thanks again!

 

[MeeshR]

Also how do I copy the formulas to have them in my spreadsheet?

Please check attachment with helper column added

Regards

 

[Mike86]

Just copy the equations in F2:G2 of bosco's file. Open your file. Select F2:G488 and hit paste. Assuming this is your entire data set, should work.