Forum Discussion
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...
My vote would go to the IFS family of functions which are several times faster than normal array formulas. With modern dynamic arrays, a single spilt range would be given by
= SIGN( COUNTIFS(Name, Name, Age, Age) > 1 )
or, within an Excel Table, the column formula should return a single cell at a time, so
= SIGN( COUNTIFS([Name], [@Name], [Age], [@Age]) > 1 )