R
RayB
i have some work that i'm trying to sort and then subtotal like info.
Column A Column B Column C
acct # $$ subtotal
what happens is that i get a check with 100 accounts, some duplicates
randomly on a list. I put that into Excel and sort column A which groups like
accounts.
What i'm looking for is this. If I have 4 accounts say row 2,3,4,5 -i'd like
C2 to say..if A2 does not equal A3 then B2 else $0.00.
But how do i tell it to check A4,A5,A6 ... I really just want a subtotal on
C5 line.
I hope that makes sense. Thank You!
Ray Brewer.
Column A Column B Column C
acct # $$ subtotal
what happens is that i get a check with 100 accounts, some duplicates
randomly on a list. I put that into Excel and sort column A which groups like
accounts.
What i'm looking for is this. If I have 4 accounts say row 2,3,4,5 -i'd like
C2 to say..if A2 does not equal A3 then B2 else $0.00.
But how do i tell it to check A4,A5,A6 ... I really just want a subtotal on
C5 line.
I hope that makes sense. Thank You!
Ray Brewer.