Find the earliest date in the column

In the attached spreadsheet, there are multiple membership nos. that have different departure date (Column C). I basically need to determine the earliest departure date for those members who have multiple entries in column D since the data are in thousands.

Many thanks!

You can use this array* formula:

=MIN(IF($D$3:$D$10=D3,$C$3:$C$10))

adjust the ranges to suit your real data, format the cell as a date, then copy down.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter, rather than the usual Enter.

Hope this helps.

Pete

Hi Pete!

Thanks for the assistance, let me quickly try it and see how it goes

Hi Pete

Can you send another array formula but this time the membership no is in column C and departure date on E?

Many thanks

Here you are:

=MIN(IF($C$3:$C$10=C3,$E$3:$E$10))

Commit with Ctrl-Shift-Enter as previously advised.

Hope this helps.

Pete