A or B

  • Thread starter Thread starter 3Suk
  • Start date Start date
3

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.
 
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 :
 
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.
Click to expand...

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

Patrick.
 
Back
Top