Need formula to find value

[mahesh8498]

Hi All,

I have data in following manner.

Cell A1 - FALSE Cell B1 - FALSE Cell C1 - MAX

In Cell D1 I want formula which will find the value other than False.

In this scenarion In cell D1 i want value to be reflected as MAX after entering formula.


I have 2 more words i.e MID and MIN and these word also can be appeared.

Basically i need a formula which will give me the value except FALSE in range of A1:C1

Your reply will be highly appriciated

 

[T. Valko]

Hi All,

I have data in following manner.

Cell A1 - FALSE Cell B1 - FALSE Cell C1 - MAX

In Cell D1 I want formula which will find the value other than False.

In this scenarion In cell D1 i want value to be reflected as MAX after entering formula.


I have 2 more words i.e MID and MIN and these word also can be appeared.

Basically i need a formula which will give me the value except FALSE in range of A1:C1

Your reply will be highly appriciated

Try this array formula**:

=INDEX(A1:C1,MATCH(TRUE,A1:C1<>FALSE,0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

 

[mahesh8498]

Thanks a lot for your help........its working fine......

 

[T. Valko]

Thanks a lot for your help........its working fine......

You're welcome. Thanks for the feedback!