New user just needs help !

[david55thomas]

My problem is knowing what functions there are available and also understanding my own need for help.

I have rows of registered people using my charity and I record donations in a cell of their particular row, then in the next column, the donation date.

I have a series of empty cells awaiting completion with this data as each person makes another donation.

I acknowledge each donation by letter in Word which accesses this data in Mailmerge.

I need to have a fixed reference cell at then end of each row, say at row ZZ which has a formula to identify the LATEST donation and to pinpoint the donated sum on that date.

I've thought about VLOOKUP, COUNT, etc but can't make these work in my head.

Any ideas please?

SMITH / ADDRESS etc / £50.00 / 07.09.2009 / NULL / NULL etc
JONES / ADDRESS etc / £20.00 / 01.09.2009 / £35.00 / 06.09.2009 / NULL / NULL / etc

Over to you !

Thanks