So, you want just the names? And there will be no more than 10 that meet the
condition? Will there ever be less than 10 that meet the condition?

Assume this data is on Sheet1 starting in cell A2:

JOE SMITH 32 YES
DEBBY ALLEN 19 NO
CHRIS JONES 45 YES
TOM WILLIAM 17 YES

Enter this formula where you want the names listed. Enter this formula as an
array using the key combination of CTRL,SHIFT,ENTER (not just ENTER):

=INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!C$2:C$5="no" ,ROW(A$2:A$5)-MIN(ROW(A$2:A$5))+1),ROWS($1:1)))

Copy down 10 rows.

If there may be less than 10 names that meet the condition then use this
version to handle any errors (also arrary entered):

=IF(ROWS($1:1)<=COUNTIF(Sheet1!C$2:C$5,"no"),INDEX (Sheet1!A$2:A$5,SMALL(IF(Sheet1!C$2:C$5="no",ROW(A $2:A$5)-MIN(ROW(A$2:A$5))+1),ROWS($1:1))),"")

Biff

"HELPME" wrote in message
...
Ok I tried the auto filter thing, not working the way i need it, here are
the
specifics again, I have a chart that looks like this on the first
worksheet:

NAME AGE CHILDREN
JOE SMITH 32 YES
DEBBY ALLEN 19 NO
CHRIS JONES 45 YES
TOM WILLIAM 17 YES etc, etc......

OK this list has about 60-80 names on it....now i have another table on
another page that has enough lines for exactly 10 of these names to be
transfered to, I know that there will be only 10 peole from the list who
answer NO to the CHILDREN column, so I wan to be able to somehow pull from
the first list(60 people) and transfer the names of the 10 without kids to
the spot I have on the second page...is this possible, i tried
sort/filter,
does not do what i need it to do, can i use a lookup somehow??? PLEASE
HELP