Unique Values

T

trumb1mj

I am trying to count unique values in column A. The problem is, eac
value is completely different and can be random. Ex: askdg123, gh67
09trop, etc.

Is there any way to keep a going count of the entire range (A3:A500)
 
B

Bob Phillips

=SUMPRODUCT((A3:A500<>"")/COUNTIF(A3:A500,A3:A500&""))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

I'll take your word for that.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top