hi
i have this following data on the excel to process:
A B C D E
1 123456 .070 3 $50 $150
2 123456 .075 1 $50 $50
3 123456 .090 4 $50 $200
4 987654 .070 1 $20 $20
5 987654 .080 2 $20 $40
where column A is: the product code of the items
B is: the sizes of the product type as per column A
C is: the unit sold for product A size B
D is: price each
E is: total $ sold
considering the data is pretty big i would like to make a summary page that looks as follows:
A B C D E F G H I J
1 PROD .070 .075 .080 .085 .090 .095 .100 .105 .110
2 123456 3 1 0 0 4 0 0 0 0
3 987654 1 0 2 0 0 0 0 0 0
i believe the tallies can be done using the SUMIFS formula... however i am at lost at getting the data from COLUMN A filtered so that it shows only one rather than many...
how do i solve this issue?
thanks in advance!
Marvin
Bookmarks