Last recorded date formula ?

[gaz67]

Hi,
What formula do I use to find out most recent date recorded from a list of clients?
Is the Maxif a good option?

Craig
Elizabeth
Linda
Roger

21/10	Linda
22/10	Craig
23/10	Roger
24/10	Craig
25/10	Craig
26/10	Elizabeth
27/10	Linda

<colgroup><col><col></colgroup><tbody>
</tbody>

Eg: i want a cell to say that Linda's most recent date was 27/10.

Thanks
Gary

 

[RasGhul]

Hi Gaz,

Assuming your data is in A & B Columns, use CTRL - SHIFT - ENTER to enter the formula as an array;

=MAX(IF($B$6:$B$12=A1,$A$6:$A$12))

 

[gaz67]

Ah Great, this works thanks RasGhul

 

[Peter_SSs]

Is the Maxif a good option?

MAXIFS is a good (standard-entry) option.

Excel Workbook
	A	B
1	Craig	25-Oct
2	Elizabeth	26-Oct
3	Linda	27-Oct
4	Roger	23-Oct
5
6	21-Oct	Linda
7	22-Oct	Craig
8	23-Oct	Roger
9	24-Oct	Craig
10	25-Oct	Craig
11	26-Oct	Elizabeth
12	27-Oct	Linda
MAXIFS