Newbie needs help!

[tbobo]

I have a small sample of may data file:

Item Number = Col1
Company/s = Col2
Number Buy = Col3
Cost/n = Col4

Item Number Company/s Number Buy Cost/n
1 2 26 8
1 3 18 432
2 1 14 44
2 1 14 44
2 1 16 44
2 1 23 44
2 1 29 44
2 1 26 44
2 1 23 44
2 1 24 44
2 1 29 44
2 1 26 44
2 1 24 44
2 1 25 356
2 1 26 356
2 1 26 356
2 1 28 356
2 1 29 356
2 1 26 356
2 1 26 356
2 1 19 356
2 1 28 356
2 1 26 356
2 1 24 356
2 1 26 356
3 1 28 44
3 1 22 44
3 1 21 44
3 1 22 76
3 1 21 76
3 1 18 76
3 1 17 76
3 1 18 76
3 1 15 76
3 1 14 76
3 1 13 76
3 1 23 76
3 1 25 188
3 2 25 244
3 2 24 244
3 2 23 244
3 1 25 316
3 1 29 316
3 1 30 316
3 1 25 316
3 1 23 316
3 1 26 316
3 1 26 316
3 1 19 316
3 1 26 316
3 1 26 316
3 1 28 316
3 2 13 324
4 1 28 264
4 1 30 264
4 1 26 264
4 1 26 264
4 1 25 264
4 1 26 264
4 1 26 264
4 1 24 264
4 1 22 264
4 1 25 264
4 1 19 264
4 1 23 264
4 1 25 264
4 1 26 264
4 1 21 264
4 1 20 264
4 1 25 264
4 1 24 264
4 1 17 264
4 1 22 264
4 1 25 264
4 1 26 264
4 1 27 264
4 1 28 264
4 1 30 264
4 1 26 264
4 1 30 264
4 1 24 264
4 1 26 264
4 1 20 264
4 1 23 264
4 1 26 264
4 1 25 264
4 1 27 264
4 1 26 264
4 1 25 264
4 1 25 264
4 1 26 264
4 1 26 264
4 1 18 264
4 1 28 264
5 1 25 56
8 1 11 132
8 1 15 132
8 2 26 292
8 2 26 472
9 2 21 296
9 2 18 296
9 2 18 296
9 2 13 296
9 2 12 296
9 2 14 296
9 2 12 296
9 2 25 296
9 2 12 296
9 2 22 296
11 1 29 128
11 1 29 128
11 1 30 128
11 1 24 428
11 1 22 428
11 1 21 428
11 1 22 488
11 1 23 488
11 1 26 488
11 1 24 488
11 2 27 488
12 1 28 28
12 1 30 28
12 1 27 28
12 1 28 28
12 1 30 28
12 3 26 60
12 3 26 60
12 3 27 60
12 1 28 80
12 1 28 80
12 1 27 80
12 1 25 80
12 1 28 80
12 1 28 80
12 1 16 132
12 1 18 132
12 1 12 132
12 1 12 132
12 3 26 188
12 3 25 188
12 2 26 192

This data file could have 4 to 8 thousand line. I am looking for hel
to have a macro which will have the following output:

Item Number = Col1
Company/s = Col2
Number Buy = Col3
Cost/n = Col4
Count = Col5
Number Buy Average =Col6

Item Number Company/s Number Buy Cost/n Count Number Buy Average
1 2 26 8 1 26
1 3 18 432 1 18
2 1 14 44 11 22.54545455
2 1 25 356 12 25.75
3 1 28 44 3 23.66666667
3 1 22 76 9 17.88888889
3 1 25 188 1 25
3 1 25 316 11 25.72727273
3 2 25 244 3 22
3 2 13 324 1 13
4 1 28 264 40 24.80487805
5 1 25 56 1 25
8 1 11 132 2 1
8 2 26 292 2 26
9 2 21 296 10 24
11 1 29 128 3 29.33333333
11 1 24 428 3 22.33333333
11 1 22 488 4 23.5
12 1 28 28 5 24
12 1 28 80 6 27.33333333
12 1 16 132 4 14.5

This data was filtered by : Item Number;Company/s;Cost/n
I then count and average

Please Help

 

[cbh35711]

Have you tried a Pivot Table?

Chris

 

[tbobo]

No-

I don't even know if you can do this Pivot table!

Thanks!

If you know how please share!

 

[Tom Ogilvy]

http://www.contextures.com/tiptech.html

look under P for pivottables.

 

[tbobo]

It is not a lot of help. I want to thank you for take the time to help
I thought this could be done with VBA script!

Can some1 help