Forum Discussion
Solved
looking for a value within the column the value is in, for uniqueness
I have a set of assumptions, in which I need one column to serve as a unique ID, per assumption. My list is much longer than attached, but for purposes of illustrating the issue, have condensed it. ...
If the goal were to select such a disjoint array your approach may well be as good as any other.
If the goal is to warn the user that they have input a non-unique ID, then that can be achieved using the entire ID range and the formula
= IF( COUNTIFS(ID,ID)>1, "Choose a Unique Code", "" )
If the goal were to select such a disjoint array your approach may well be as good as any other.
If the goal is to warn the user that they have input a non-unique ID, then that can be achieved using the entire ID range and the formula
= IF( COUNTIFS(ID,ID)>1, "Choose a Unique Code", "" )
PeterBartholomew1, like yours. Nice and clean. Thanks.
