View Single Post
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default

Hi Phil
In cell AA1
=AND(A1="phil",B1="Tony")+AND(A1="Tony",B1="Phil") *1

--
Regards

Roger Govier


"Phil" wrote in message
. uk...
I am trying to find a formula that looks at a range of cells, a2:b11, and
if
a cell in the range has a value Phil and its adjacent cell in the other
column
has a value Tony then AA1=1, if no adjacent cells match the criteria AA1
=0. The names can be in either column.

For instance...

A B
Phil Tony would give AA1 value 1
Tony Phil would also give AA1 value 1
xxx yyy would give AA1 value 0

Thanks