Need a function

[SB]

Can anyone help me come up with a function that will:

Scan a list of names and count how many of the names have a corresponding "yes" value beside them. However, if the name is listed twice, the function should ignore the redundant listings. Therefore only counting a recurring name the first time.

The data would be in two columns, say A1:B10.
With names in Coulmn A and "Yes" or "No" in column B.

 

[RichardS]

Jeez, Aladin, where do you pull these things from??

 

[Russell Hauf]

On 2002-03-26 16:30, Dave Patton wrote:

Russell

You stated
" Sumproduct won't work with names. "

Would you clarify?

Sorry, I was thinking that the original poster wanted a list of names with the yes values - I was thinking in terms of returning the list of names instead of the total number of unique names, like I should have been (Sumproduct won't sum text, but that's not what you were suggesting).

Sorry, next time I'll read more carefully!

-rh