Hi Mathur,
If you dont mind can u explain the syntax that u used, cuz i need to use the
same syntax that u used with data taken from 2 different workbooks.
"Ashish Mathur" wrote:
Hi,
Try this array formula (Ctrl+Shift+Enter)
=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2))
$A$10 contains Jim. Now copy the formula down
A1:A7 would contain names. B2:B7 would contain company names (Dell, HP
etc.)
Hope this helps
Regards,
Ashish Mathur
"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?
|