Hi all!

Want to know if there is any faster way in excel on solving my LONG
problem. I have a worksheet as following:

1, $3
1, $2
1, $1
2, $5
2, $4
3, $4.50

P.S. In actual worksheet is D1 contains '1' and I1 contains '$3'

The first column is invoice number and the second column is amount. My
actual worksheet has over 5000 lines of those data. My work is trying
to get the total of each invoice. It should look something like this:

1, $6
2, $9
3, $4.50

I'm not sure this there is a build in function in excel on doing this
or this must done by programming the excel. If you can think of any
way. Please let me know and thank you very much on reading my post.


--
smash123
------------------------------------------------------------------------
smash123's Profile: http://www.excelforum.com/member.php...o&userid=29974
View this thread: http://www.excelforum.com/showthread...hreadid=542888