Finding latest date where for multiple entries

Hi

I have 2 columns where 1 column is a list of names and second column in which is dates of payments, I need to identify the latest date of payment for each name... How would i do this?

Any help would be great

Crystal

Obtain a unique list of names, say in column A of another sheet, then you can use this array* formula in B2 of that sheet (assuming row 1 has headers):

=MAX(IF(Sheet1!A$2:A$100=A2,Sheet1!B$2:B$100))

Adjust the cell ranges to suit your data (it is not advisable to use full-column references with array formulae), then copy down to cover your unique list.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual <Enter>, but it can be copied down in the usual way(s).

Hope this helps.

Pete

its sorted by name then by payment date