Hi All,

I have two columns in a spreadsheet, column A - a list of dates on which
transactions took place. Column B the value of the transaction.
More than one transaction can take place on one day.
I can have a list of months somewhere on the sheet if that will help.
What I want is to get the value of the last transaction for each month.

Eg.

1/4/04 100
2/4/04 200
3/4/04 100
4/4/04 400
4/4/04 500 Last transaction
1/5/04 600
2/5/04 300
28/5/04 400 Last transaction
1/6/04 500
28/6/04 100 Last transaction


Many thanks

Jim