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
<colgroup><col><col></colgroup><tbody>
</tbody>
Eg: i want a cell to say that Linda's most recent date was 27/10.
Thanks
Gary
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