Is there any way to find out, with the help of a formula, whether all elements of a certain range are unique or not without having to program a macro in VBA?
Let us say that the elements in column A
are K1
in cell A1
, K2
in cell A2
and so on. I now want to check whether all of the elements in column A
are unique or not. If they are unique, return True
in cell B1
, if they are not, return False
.
It would be great if this could also work for checking rows so that a formula can, for instance, find out whether all elements in row 1
are unique or not and return True
if they are and False
when they are not.