counting unique values of text
 

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!!

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!!

counting unique values of text
 

For this:
.. count the number of A's in column B that don't equal "FALSE" in column A?

Try: =SUMPRODUCT((A1:A5<FALSE)*(B1:B5="A"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

counting unique values of text
 

You are some kind of sorcerer!! Perfect, thank you.

"Max" wrote:

For this:
.. count the number of A's in column B that don't equal "FALSE" in column A?

Try: =SUMPRODUCT((A1:A5<FALSE)*(B1:B5="A"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

counting unique values of text
 

Glad it worked ok for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"jake" wrote in message
...
You are some kind of sorcerer!! Perfect, thank you.