How to check multiple entries on 2 different column

[hakim_tanzil]

Hi Guys

I need a formula to check multiple entries occur

Below is the table

A B C D
Date Name.1 Name.2 Check

25/04 Andy John "Error"
25/04 Chris Andy "OK"
25/04 John Andy "Error"


Any inputs would be greatly appreciated

 

[SanjayGMusafir]

Update your current version of excel and platform to help you in an optimal way.

 

[Joe4]

Regarding Sanjay's response, it may not be apparent what he means.
You can update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[hakim_tanzil]

Hi Sanjay,

Thanks for your response

I mostly use older version of Excel 2016

 

[hakim_tanzil]

Thanks to Joe4 also for the information. Will update

 

[SanjayGMusafir]

I mostly use older version of Excel 2016

Thanks for updating @hakim_tanzil But I'm not much acquainted with older versions of excel now. Hope this post catches the eye of someone better than me.

 

[Joe4]

This seems to work for me:

Formula in cell D2 (and copy down):

=IF(COUNTIFS(B$2:B$7,$B2,C$2:C$7,$C2)+COUNTIFS(B$2:B$7,$C2,C$2:C$7,$B2)>1,"Error","OK")

 

[hakim_tanzil]

Thanks Joe4.

This is as simple as it is, but yet I cant figure it out.

 

[hakim_tanzil]

Hi Joe4,

I tried your formula, and it works great. But what if sometimes we only input 1 name

25-Apr John

 

[Joe4]

Hi Joe4,

I tried your formula, and it works great. But what if sometimes we only input 1 name

25-Apr John

I don't understand. Your question was to check for duplicates among two different columns.