| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a Lookup of some sort cont.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| Filter, sort, lookup from other sheet | Excel Discussion (Misc queries) | |||
| HOW TO SORT A COLUMN THE SAME AS ANOTHER COLUMN WITH SIMILAR CONT. | Excel Worksheet Functions | |||
| A sort of lookup or match | Excel Worksheet Functions | |||
| Lookup and Sort Question | Excel Discussion (Misc queries) | |||
Threaded Mode
