Hi,
I am trying to filtering unique records based on more than two columns. This formula does work fine for me but it doesnt work in the xcelsius tool as it does not support the countifs and column function. Can anyone suggest me an alternative function to use.
Here is the formula:
=IF(ISNA(INDEX($A$175:$F$189, MATCH(0, COUNTIFS($A$192:$A192, $A$175:$A$189, $B$192:$B192, $B$175:$B$189, $C$192:$C192, $C$175:$C$189, $D$192:$D192, $D$175:$D$189,$E$192:$E192,$E$175:$E$189,$F$192:$F192,$F$175:$F$189), 0), COLUMN(A1))),"",INDEX($A$175:$F$189, MATCH(0, COUNTIFS($A$192:$A192, $A$175:$A$189, $B$192:$B192, $B$175:$B$189, $C$192:$C192, $C$175:$C$189, $D$192:$D192, $D$175:$D$189,$E$192:$E192,$E$175:$E$189,$F$192:$F192,$F$175:$F$189), 0), COLUMN(A1)))
Kind regards,
Rohini Sreedhar.
Bookmarks