B
BobC
I'm using Excell 2003. I am trying to find a formula that will take the
text contents of Cell "A" and compare it to a range of cells
(containing text), if there is a match of "A" to any items in the range
I want to present a value of 1 (if true) and 0 (if false) into Cell
"B".
example:
A B Range
1 joe 1 joe
2 bill 0 frank
3 sally 0 linda
4 jeff 0 betty
Has anyone tried to do this?
Thanks,
BobC
text contents of Cell "A" and compare it to a range of cells
(containing text), if there is a match of "A" to any items in the range
I want to present a value of 1 (if true) and 0 (if false) into Cell
"B".
example:
A B Range
1 joe 1 joe
2 bill 0 frank
3 sally 0 linda
4 jeff 0 betty
Has anyone tried to do this?
Thanks,
BobC