Hi,
I just came accross another problem and I am hoping for help.
I have many multiple items in column A(sheet1) from various suppliers. Just
as an example: One of the items could have been purchased from four
different suppliers (maybe three or five or only two suppliers). I have no
problems to sumif the qty and total values of each item in sheet2 as a
unique item. The problem I have is to list the various suppliers on the same
row where the unique items are. I am dealing here with 40000 rows of data.
Example sheet1:
.................qty.............value........supplier
Apple........30.............3500.......company1
Apple........50.............4000......company2
Apple........60............7000........company3
Apple........70...........2000........company4
Apple........70...........2000.........company2
Pear...........150.........6000........smith
Pear...........90...........7000.........vista
Pear...........30...........7000.........a company
Pear...........20...........2000.........vista
Example sheet2:
......................qty.............value..........supplier1.............s
upplier2...............supplier3...................supplier4
Pear.............521............20100...........smith...............vista...
...................a company
Apple...........450............15700..........company1.......company2.......
......company3....................company4
etc.
You help would be very much appreciated. This looks like a difficult
one to me.
Andonny
I just came accross another problem and I am hoping for help.
I have many multiple items in column A(sheet1) from various suppliers. Just
as an example: One of the items could have been purchased from four
different suppliers (maybe three or five or only two suppliers). I have no
problems to sumif the qty and total values of each item in sheet2 as a
unique item. The problem I have is to list the various suppliers on the same
row where the unique items are. I am dealing here with 40000 rows of data.
Example sheet1:
.................qty.............value........supplier
Apple........30.............3500.......company1
Apple........50.............4000......company2
Apple........60............7000........company3
Apple........70...........2000........company4
Apple........70...........2000.........company2
Pear...........150.........6000........smith
Pear...........90...........7000.........vista
Pear...........30...........7000.........a company
Pear...........20...........2000.........vista
Example sheet2:
......................qty.............value..........supplier1.............s
upplier2...............supplier3...................supplier4
Pear.............521............20100...........smith...............vista...
...................a company
Apple...........450............15700..........company1.......company2.......
......company3....................company4
etc.
You help would be very much appreciated. This looks like a difficult
one to me.
Andonny