count and display unique values
Cell B1: =A1
Cell B2: =IF(ISERROR(MATCH(0,COUNTIF(B$1:B1,$A$1:$A$20&""), 0)),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(B$1:B1,$A$1:$A$2
0&""),0)))
enter as an array formula, commit with Ctrl-Shift-Enter, then copy down
Cell C1: =IF(B1<"",COUNTIF(A:A,B1),"")
and copy down
--
HTH
RP
(remove nothere from the email address if mailing direct)
"joe" wrote in message
...
I need to count and display unique values
a
a
b
b
b
cc
cc
cc
cc
the is a formula to count the number of unique times a value exists but I
also want to display the values in a column.
Thnaks
|