Return Value If Two Conditions occur

Hatman · 01-26-2006, 04:30 PM

Hello all, thanks in advance for a yay or nay on this question.

This is what I would like my spreadsheet to do:

I have one column with names
One column which could have data inputed (Lets say age)

Now I need in another cell the following to happen :
Return the name(s) from the names column in this cell only if in the second
column there is a number or value in said field.

Example:

Column A Column B
Names Value(could be number or blank)
Names2 Value(could be number or blank)
Names3 Value(could be number or blank)
etc...

Report Field : Only names from column A if the name in Column A has
corresponding data in Column B.

Is this doable? Am I crazy?

Thanks

John Michl · 01-26-2006, 04:40 PM

How about...
In a column in Sheet2

IF(ISVALUE(Sheet1!B1),Sheet1!A1,"")

This will give you the name(s) if there is a number in column B. If
not, it will show a blank cell.

- John

George Nicholson · 01-26-2006, 04:45 PM

Any particular reason you want a 3rd column?

No addtional column approach:
Select B2, then Data>Filter>AutoFilter. Then select "Non-Blanks" in the
drop-down box.
The result would be just those rows (columns A & B) with a value in column
B.

HTH,
--
George Nicholson

Remove 'Junk' from return address.

"Hatman" <[email protected]> wrote in message
news:[email protected]...
> Hello all, thanks in advance for a yay or nay on this question.
>
> This is what I would like my spreadsheet to do:
>
> I have one column with names
> One column which could have data inputed (Lets say age)
>
> Now I need in another cell the following to happen :
> Return the name(s) from the names column in this cell only if in the
> second
> column there is a number or value in said field.
>
> Example:
>
> Column A Column B
> Names Value(could be number or blank)
> Names2 Value(could be number or blank)
> Names3 Value(could be number or blank)
> etc...
>
> Report Field : Only names from column A if the name in Column A has
> corresponding data in Column B.
>
> Is this doable? Am I crazy?
>
> Thanks
>
>
>

**sunnyland** · 01-26-2006, 04:53 PM

***if you checked my answer recently, sorry I edited a few times as I didn't understand properly the question at fisrt, sorry my mistake

Dear Hatman,

This formula should work for number or empty in the age field

=CHOOSE(ISNUMBER(F3)+1,"",E3)

This formula should work for text or empty in the age field

=CHOOSE(ISTEXT(F3)+1,"",E3)

this formula should work if text or number or empty in the age field
*** the or test for any criteria in the brackets and return true if any condition is met
or( cond1,cond2,cond3)

=IF(OR(ISNUMBER(F3),ISTEXT(F3)),E3,"")

Please, let me Know by a

Sunnyland

John Michl · 01-26-2006, 05:55 PM

The original poster said the result needed to be in a second worksheet.
I wasn't adding a column just follow OP requirements.

John

George Nicholson · 01-30-2006, 04:35 PM

John:
My question was meant for the OP (questioning the requirement), not
your not your perfectly proper response to the OP.

--
George Nicholson

Remove 'Junk' from return address.

"John Michl" <[email protected]> wrote in message
news:[email protected]...
> The original poster said the result needed to be in a second worksheet.
> I wasn't adding a column just follow OP requirements.
>
> John
>