A or B

[3Suk]

dear all
I have below a table below

colA colB
10 C
10 O
10 C
20 C
20 C
20 C

please advise a formula to :
in all cells contain 10, if there is one 'O', then return me the 'O', else return a 'C'.

in above, when search all '10' rows, I expect the result will be 'O'
when search all '20' rows, the result will be 'C'

Thanks,
PL.

 

[isabelle]

hi,

i have assumed that the searched value (10 or 20) is in cell C1

this formula must be validated with Ctrl + Shift + Enter
=IF(NOT(ISERROR(MATCH(C1&"O",A1:A10&B1:B10,0))),"O","C")

isabelle

Le 2014-07-25 00:17, 3Suk a écrit :

 

[3Suk]

dear all

I have below a table below



colA colB

10 C

10 O

10 C

20 C

20 C

20 C



please advise a formula to :

in all cells contain 10, if there is one 'O', then return me the 'O', else return a 'C'.



in above, when search all '10' rows, I expect the result will be 'O'

when search all '20' rows, the result will be 'C'



Thanks,

PL.

dear isabelle and ron,
thanks for yours help, both works.

Patrick.