Count unique if text
Try this:
Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):
=SUM(N(FREQUENCY(IF(ISTEXT(B1:B13),MATCH(B1:B13,B1 :B13,0)),MATCH(B1:B13,B1:B13,0))0))
Biff
"Mike Fogleman" wrote in message
...
Column B has a mix of text and numbers. I want to count unique text values
only.
The answer to the following list would be 8.
P2-2
P2-2
P2-7
P1-3
P-HE
P2-7
6
P11-2
P12-8
P12-8
P12-1
P12-1
P11-3
Mike F
|