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)

"Yan" wrote in message
...
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?

The one you gave me yesterday, for some reason does not work!

Don't know why?

"Bob Phillips" wrote:

Same as I gave you yesterday.

--
HTH

Bob

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

"Yan" wrote in message
...
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?

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)

"Yan" wrote in message
...
The one you gave me yesterday, for some reason does not work!

Don't know why?

"Bob Phillips" wrote:

Same as I gave you yesterday.

--
HTH

Bob

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

"Yan" wrote in message
...
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?

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.

--
Regards

Roger Govier


"Yan" wrote in message
...
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?