Compare columns

[anand3dinesh]

Gents,

Please can anyone help me with comparing 3 columns in the excel?
see attached image i have a report that has 3 diffirent dates and time. if any of 3 column has same data i would like to add this in compare column to filter out.

Thanks for your help

 

[etaf]

any the same in 1 row or the whole column?

Will all 3 column be populated or will there be a situation where 1 column has blank cells

Assuming ALL three are filled in

=IF(A2="","",IF(OR(A2-B2=0,A2-C2=0,B2-C2=0),"Match","" ))

 

[anand3dinesh]

Thanks mate that worked

 

[anand3dinesh]

any the same in 1 row or the whole column?

Will all 3 column be populated or will there be a situation where 1 column has blank cells

Assuming ALL three are filled in

=IF(A2="","",IF(OR(A2-B2=0,A2-C2=0,B2-C2=0),"Match","" ))

Thanks mate that worked

 

[etaf]

you are welcome