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