counting unique values of text
Try this array formula** :
=COUNT(1/FREQUENCY(IF(ISTEXT(A2:A6)*(B2:B6="A"),MATCH(A2:A6 ,A2:A6,0)),ROW(A2:A6)-MIN(ROW(A2:A6))+1))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
"jake" wrote in message
...
Hi,
Column A is referencing unique text values from another spreadsheet which
is
where the "FALSE" comes from. How do I count how many A's are in column B
but only refer to unique names in column A? The other problem is, this is
a
template, so column A is going to change completely. So is it possible to
count the number of A's in column B that don't equal "FALSE" in column A?
col. A col. B
Jim A
FALSE A
Pam B
David A
FALSE A
I've seen similar threads but I couldn't find any that involved text.
Please help!!
|