Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An Advance IF
Dear all
I have in cell H14 = A AND I14= FALSE, J14=FALSE, K14=FALSE IN H15=FALSE I15=B, J15=FALSE, K15=FALSE IN H16=FALSE I16=FALSE J16=C, K16=FALSE So i want in each line and bring in B14, lets say that if the cell H14, OR I14, OR J14, OR K14 is not FALSE then bring me the value. I want to check between the four cell the value and if not FALSE to bring me the respective value. In each line only one cell has a value, the rest three has value false. Any good ideas for advance If, or anything else? Thanks in advance Manos |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An Advance IF
In B14: =LOOKUP(2,1/(H14:K14<FALSE),H14:K14)
copy down "Manos" wrote: Dear all I have in cell H14 = A AND I14= FALSE, J14=FALSE, K14=FALSE IN H15=FALSE I15=B, J15=FALSE, K15=FALSE IN H16=FALSE I16=FALSE J16=C, K16=FALSE So i want in each line and bring in B14, lets say that if the cell H14, OR I14, OR J14, OR K14 is not FALSE then bring me the value. I want to check between the four cell the value and if not FALSE to bring me the respective value. In each line only one cell has a value, the rest three has value false. Any good ideas for advance If, or anything else? Thanks in advance Manos |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An Advance IF
=INDEX(H14:K14,1,MIN(IF(H14:K14<FALSE,COLUMN(H14: K14)))-MIN(COLUMN(H14:K14))+1)
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Manos" wrote in message ... Dear all I have in cell H14 = A AND I14= FALSE, J14=FALSE, K14=FALSE IN H15=FALSE I15=B, J15=FALSE, K15=FALSE IN H16=FALSE I16=FALSE J16=C, K16=FALSE So i want in each line and bring in B14, lets say that if the cell H14, OR I14, OR J14, OR K14 is not FALSE then bring me the value. I want to check between the four cell the value and if not FALSE to bring me the respective value. In each line only one cell has a value, the rest three has value false. Any good ideas for advance If, or anything else? Thanks in advance Manos |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An Advance IF
Not very sophisticated but this works
=SUBSTITUTE(H14&I14&J14&K14,"FALSE","") best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Manos" wrote in message ... Dear all I have in cell H14 = A AND I14= FALSE, J14=FALSE, K14=FALSE IN H15=FALSE I15=B, J15=FALSE, K15=FALSE IN H16=FALSE I16=FALSE J16=C, K16=FALSE So i want in each line and bring in B14, lets say that if the cell H14, OR I14, OR J14, OR K14 is not FALSE then bring me the value. I want to check between the four cell the value and if not FALSE to bring me the respective value. In each line only one cell has a value, the rest three has value false. Any good ideas for advance If, or anything else? Thanks in advance Manos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell advance i.e. tab | Excel Discussion (Misc queries) | |||
advance filtering | Excel Discussion (Misc queries) | |||
I need a little help...thanks in advance | Excel Discussion (Misc queries) | |||
Here's one for you...(thanks for the help in advance) | Excel Discussion (Misc queries) | |||
advance filter | Excel Discussion (Misc queries) |