Jaymond Flurrie
Wellknown Member
 Joined
 Sep 22, 2008
 Messages
 901
 Office Version

 2016
Is there any easy function that returns true/false based on whether the passed range argument has only unique values (so no value is twice on the list)?
I have so far done this so that I use two columns and make a countifsformula that compares the value on the other column to all values on the other column and counts the amount of similar rows and then I take max of those numbers and compare that to number one. It just seems pretty complicated. And more than anything, it works only with Excel 2007.
I have so far done this so that I use two columns and make a countifsformula that compares the value on the other column to all values on the other column and counts the amount of similar rows and then I take max of those numbers and compare that to number one. It just seems pretty complicated. And more than anything, it works only with Excel 2007.