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

[TABLE="width: 218"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]21/10[/TD]
[TD]Linda[/TD]
[/TR]
[TR]
[TD]22/10[/TD]
[TD]Craig[/TD]
[/TR]
[TR]
[TD]23/10[/TD]
[TD]Roger[/TD]
[/TR]
[TR]
[TD]24/10[/TD]
[TD]Craig[/TD]
[/TR]
[TR]
[TD]25/10[/TD]
[TD]Craig[/TD]
[/TR]
[TR]
[TD]26/10[/TD]
[TD]Elizabeth[/TD]
[/TR]
[TR]
[TD]27/10[/TD]
[TD]Linda[/TD]
[/TR]
</tbody>[/TABLE]

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