| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function from a different sheet!
I need to find all female and all male that is on 1 sheet and created the
result onto the other sheet..... I need to take all info beside each F and created a list and Each M beside the name a created a list into another sheet, all the information beside need to be taken as well.... Basically, Ex: M Yan 252 3000 M BOB 246 25500 F Kim 256 30124 F Pat 300 25466 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup function from a different sheet!
If you need to take an entire row of information (all males) and get it to
another sheet, use an Autofilter. You can specifiy just about any criteria and the whole row is visible for copy/paste -- Gary''s Student - gsnu200732 "Yan" wrote: I need to find all female and all male that is on 1 sheet and created the result onto the other sheet..... I need to take all info beside each F and created a list and Each M beside the name a created a list into another sheet, all the information beside need to be taken as well.... Basically, Ex: M Yan 252 3000 M BOB 246 25500 F Kim 256 30124 F Pat 300 25466 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet lookup | Excel Discussion (Misc queries) | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
| Lookup from another sheet | Excel Worksheet Functions | |||
Linear Mode
