View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jake Jake is offline
external usenet poster
 
Posts: 83
Default 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!!