Excel 97 Find last in list of similiar numbers

Joined
May 11, 2007
Messages
11
Reaction score
0
I have a columns listing account numbers with the total beside and the subtotal of each account beside that.
100 $40.00 40.00
100 30.00 70.00
etc etc

How do I have formulae just to show the last subtotal in each account, probably in a fourth column. So only $70.00 would show.

Thks

Charlie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top