compare multiple cells

[linkn00]

Is there a way to compare all cells in a row against each other to make sure they are not the same?

 

[footoo]

For whole rows (row 1 in the formula) :
=IF(SUMPRODUCT((COUNTIF(1:1,1:1)-1)*(1:1<>""))>0, "Dup's","No Dup's")

If you don't want for whole rows, change 1:1 to required range.

 

[linkn00]

Thanks a lot, exactly what i am looking for. Such a life saver

 

[Peter_SSs]

I suggest that you update your Account details (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.

IF you have Excel 365 with the new Dynamic Array functions, this would be another way. With limited testing this also seems to be significantly faster when dealing with large ranges (like whole rows)

=IF(COUNTA(UNIQUE(FILTER(1:1,1:1<>""),1))=COUNTA(1:1),"No Dup's","Dup's")