Vlookup Function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do some lookup, to gett all males stats and female stats, that
are in 10 different group...

EX:

Team 1

Female France Bigras 3 - 985 - 256
and so on...

and

Male - Mike Fisher 3 1200 - 450
and so on...

I try the Vlookup function, but it only comes back with the first result, i
have about 30 mens and 30 womens, a i need to get all result one under each
other in a different sheet...

Can you help?
 
Same as I gave you yesterday.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
We need a bit more info if you want some help to sort it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi

One way
Apply an Autofilter to your header row.
Filter for Male
Select the visible rows by marking their row numbers and copy to a new
location on your worksheet.
Delete the visible rows

You now have 2 distinct sets of data upon which to perform your
statistics.
 
Back
Top