Hi,

I have like 3000 job #'s...i cant filter each n every job number out. i need
a quicker way to do that. I thought vlookup would help but not when it have
repeated job numbers.

"Richard Buttrey" wrote:

On Fri, 7 Oct 2005 07:48:07 -0700, "nick"
wrote:

Hi,

I have a huge file with 10,000 records with like +25 rows and some of the
jobs are repeated several times. Using the Job as the reference in vlookup i
am trying to populate the data in a different worksheet, but vlookup just
takes the list row information of a perticular job but i want it to take the
data from all the lines for that job. EX:
Jim Dell
Jeff HP
Carl Compaq
Jim Toshiba
Carl Sony
Jim Lenovo
Jeff IBM

I want the data to populated in this way:
Jim dell
Jim toshiba
Jim lenovo
but its populating like:

Jim dell
Jim dell
Jim dell

Can someone help me on this? i found some formulas but those are for
relatively small data, but how wld i do it with such a huge data?

Vlookup will only return one value.

Do you need a formula at all? Can't you simply Auto Filter the data in
place on the Job number column, and then filter again on the Name
column? Selecting "Jim" will filter out all Jim's equipment.

Depending what you want to do you could also use Advanced Filter to
copy the filtered records somewhere else.

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________