Comparing 3 names

Question

I am looking for best logic for comparing 3 names. Output will have records with same names. (i.e., 3 personnels cannot be same)

ID   applicant1  applicant 2  applicant3

1     John          Neil             Ben

2     John          Neil             John

3     John          Neil             Neil

4     John          John             Ben

5     John          Neil             Ben

6     John          John           John

7     John          Neil             Ben

so output will have

ID   applicant1  applicant 2  applicant3

2     John          Neil             John

3     John          Neil             Neil

4     John          John           Ben

6     John          John           John

Best,

Aakash

ArtApa · Answer

Hi @Akash__on - Here is a less dynamic, but more laconic solution:

ComparingNamesAA01.yxmd

ArtApa · Answer

Hi @Akash__on - Here is a possible solution:

ComparingNamesAA.yxmd

ShankerV · Answer

Hi @Akash__on

If in other hand, if you also need all the 3 names in the output as shared below.

so output will have

ID   applicant1  applicant 2  applicant3

2     John          Neil             John

3     John          Neil             Neil

4     John          John           Ben

6     John          John           John

Just tweak the formula to below, it will fetch the desired output.

if [app1]=[app2] and [app2]=[app3]
then 1
elseif [app1]=[app2] or [app1]=[app3] or [app2]=[app3]
then 1
else 0
endif

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V