Unique Values
 

I am trying to count unique values in column A. The problem is, each
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)?


--
trumb1mj
------------------------------------------------------------------------
trumb1mj's Profile: http://www.excelforum.com/member.php...o&userid=34847
View this thread: http://www.excelforum.com/showthread...hreadid=546877

Unique Values
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"trumb1mj" wrote in
message ...

I am trying to count unique values in column A. The problem is, each
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)?


--
trumb1mj
------------------------------------------------------------------------
trumb1mj's Profile:
http://www.excelforum.com/member.php...o&userid=34847
View this thread: http://www.excelforum.com/showthread...hreadid=546877

Unique Values
 

\\\\\\\



:)


--
trumb1mj
------------------------------------------------------------------------
trumb1mj's Profile: http://www.excelforum.com/member.php...o&userid=34847
View this thread: http://www.excelforum.com/showthread...hreadid=546877

Unique Values
 

I'll take your word for that.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"trumb1mj" wrote in
message ...

\\\\\\\



:)


--
trumb1mj
------------------------------------------------------------------------
trumb1mj's Profile:
http://www.excelforum.com/member.php...o&userid=34847
View this thread: http://www.excelforum.com/showthread...hreadid=546877