How can I make Excel return the text in column A only if there is.
 

Seems simple to me but I can't pull it off!!!

I'm trying to have my spreadsheet return the text value of sheet 1, column
A. Only if there is a value in column C.

Sounds easy enough but I have 30 value's on sheet one that need to spread to
sheets 2,3,and 4 which only have room for 10 values each. Is there a formula
that will allow me to search the 30 rows in sheet one and return only the 10
which contain a value in column C

You should be able to do that using datafilteradvanced filter, you need a
header in Sheet1, assume the headers are in A1:C1, then the data is in A2:C31,
start in sheet2, first make a filter criteria, assume we use E1:E2 in sheet2,
leave E1 blank and in E2 put =C2<"", now select for instance A1 in sheet2,
do datafilteradvanced filter, select the list range Sheet1!$A$1:$C$31,
then in the criteria range use Sheet2!$E$1:$E$2, finally check copy to
another location and once again select A1 in sheet2 Sheet2!$A$1, click OK


Regards,

Peo Sjoblom

"phatbusa" wrote:

Seems simple to me but I can't pull it off!!!

I'm trying to have my spreadsheet return the text value of sheet 1, column
A. Only if there is a value in column C.

Sounds easy enough but I have 30 value's on sheet one that need to spread to
sheets 2,3,and 4 which only have room for 10 values each. Is there a formula
that will allow me to search the 30 rows in sheet one and return only the 10
which contain a value in column C