How to find the last date in a list?

[Dougie12.]

Hi.

I'm trying to find a formula that can be input in the yellow cells shown, which automatically searches for the last date seen/entered for that particular client. I wish to be able to sort Column A and look for all client's seen in say "January" and it show the last date the client was seen that year. Hopefully the example will be clear.

Any help would be great.

Thanks

[martindwilson]

=MAX(IF($B$3:$B$12=B3,$A$3:$A$12)) array entered wit ctrl+shift+enter will do it
or this standard formula
=MAX(INDEX(($B$3:$B$25=B3)*$A$3:$A$25,0))

[Dougie12.]

Thank you Martin, that's brilliant, just what I need.

Darren