Enter your list of account numbers in a column, let's say Column F,
starting at F2...

G2, copied down:

=LOOKUP(2,1/($A$2:$A$100=F2),$B$2:$B$100)

Hope this helps!

In article ,
(Edgar Thoemmes) wrote:

Hi

I have a table set out as follows,

Account Date Text Amount
31405535 01/01/04 nnnn 100000
31405535 12/12/03 tttt 222222
31405535 03/03/05 ttt 122456

There are 5 different accounts which could be entered under Account.
The list is a export from out bank statement, I would like a formula
to display the last date of transaction per account number. For eg in
the above list I would like the formula to return 03/03/05.

Can anyone help?

TIA