I need to compare two columns of data. The first column will have names, A, B, C, D,.... and the second column will have yes, no, and blanks. I need to be able for a given value in the first column to be able to count the number of cells in the second column that are in the same row where the given value in the first column is that have either "yes" or "no" in one formula, then in a seperate formula count the blanks.
For Example<pre>
Column 1 Column 2
Bill Yes
Steve No
Bill Yes
Steve
Jim Yes
Bob No
Bill No
Bill
Steve No</pre>
Yes/No output for Bill=3
Blank output for Bill=1
Yes/No output for Steve=2
Blank output for Steve=1
....
It seems simple, but I cannot get past looking for "Bill" and if "Yes" in the second column then count. I can count one IF statement, but am not able to count a second IF statement.
Any help or hints appreciated!
Thanks,
Brian
EDIT: tags added
This message was edited by PaddyD on 2002-12-16 16:57
For Example<pre>
Column 1 Column 2
Bill Yes
Steve No
Bill Yes
Steve
Jim Yes
Bob No
Bill No
Bill
Steve No</pre>
Yes/No output for Bill=3
Blank output for Bill=1
Yes/No output for Steve=2
Blank output for Steve=1
....
It seems simple, but I cannot get past looking for "Bill" and if "Yes" in the second column then count. I can count one IF statement, but am not able to count a second IF statement.
Any help or hints appreciated!
Thanks,
Brian
EDIT: tags added
This message was edited by PaddyD on 2002-12-16 16:57