Saturday, March 29, 2014

Formula to count unique values in my list of data:

Formula to count unique values in my list of data:

=SUM(IF(FREQUENCY(MATCH(A2:A9,A2:A9,0),MATCH(A2:A9,A2:A9,0))>0,1))

No comments:

Post a Comment