Forum Discussion

sagarpdl's avatar
sagarpdl
Copper Contributor
Aug 26, 2020

Formula help VLOOKUP?XLOOKUP?

Hi, Could you please help me on this? There are names of students in first column and their age in second column. There are many same name, same age students, only few same name students have differ...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Aug 26, 2020

sagarpdl, as entered in C2 in the attached file, the formula to determine whether or not a student has the same name and age as another is:

=--(SUMPRODUCT(--(A:A&B:B=A2&B2))>1)