SOURCE
***************************
ITEM NUMBER
A 2
A 4
B 2
A 10
C 6
C 7
B 4
G 2
L 8
RESULT
*******************
ITEM TOTAL(NUMBER*100)
A 1600
B 600
C 13
G 2
L 8
Can someone please help me to write a macro for this ?????????????? This is very urgent please help .
The easiest way to do this is with a Pivot table, using a calculated field for the multiplication by 100.
The next best thing would be a formula solution with Sumif or Sumproduct.
The last thing to attempt would be a macro, because it would just re-invent the wheel for the functionality that Excel already provides.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks