View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hatman
 
Posts: n/a
Default 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