Lookup function from a different sheet!

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a list using a Lookup 2
Making a list with Lookup function 1
Vlookup Function? 4
=IF(AND Function 1
consolodating info from different sheets with different info 3
filtering data for analysis 6
lookup question 1
Particulars data Filter from sheet 1 to sheet 2 automatically 4

Top