Here's one way, try this in J6
=C6, then in J7
=IF(C7=C6,"",C6) copy down column J, then in K6
=SUMPRODUCT(--($C$6:$C$72=J6)*($H$6:$H$72)) copy down column K
This will total against each change of account number, where no account number zero, then copy > paste special values and sort column J & K by J
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thank you for your help. I tried what you suggested and I seem to be getting a #value! error sign in column "K". Would it be possible for you to show me what you did using my sample attachment? Thanks again!!
Here you go, all you need to do then is to copy columns J & K, then Paste Special > Values, then sort by column J
Your assistance was greatly appreciated!!!
Glad to help - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks