Vlookup Function?

Y

Yan

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?
 
B

Bob Phillips

Same as I gave you yesterday.

--
HTH

Bob

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

Bob Phillips

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)
 
R

Roger Govier

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.
 

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

Top