Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value If Two Conditions occur
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value If Two Conditions occur
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value If Two Conditions occur
Any particular reason you want a 3rd column?
No addtional column approach: Select B2, then DataFilterAutoFilter. 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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value If Two Conditions occur
Dear Hatman, This formula should work =CHOOSE(ISNUMBER(F3)+1,"",E3*F3) Please, let me Know by a ;) Sunnyland -- sunnyland ------------------------------------------------------------------------ sunnyland's Profile: http://www.excelforum.com/member.php...o&userid=30871 View this thread: http://www.excelforum.com/showthread...hreadid=505495 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value If Two Conditions occur
The original poster said the result needed to be in a second worksheet.
I wasn't adding a column just follow OP requirements. John |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value If Two Conditions occur
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" wrote in message oups.com... The original poster said the result needed to be in a second worksheet. I wasn't adding a column just follow OP requirements. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return value from list many conditions | Excel Worksheet Functions | |||
2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions | |||
Function to check list for specific conditions and return an answe | Excel Discussion (Misc queries) | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |