Dupes in a range
How can I make this formula respond ONLY to two-digit values in a range? (Array Entered)
=IF(MAX(COUNTIF(Data1,Data1))1,"Y","N")
Where the values may also be values-stored-as-text.
This returns "Y" because of the two 15's
1589 15 1789
189 4 189
2 15 6
This returns "N" ignoring the two 189's
1589 16 1789
189 4 189
2 15 6
Thanks,
Howard
|