Hi,
Hoping someone can assist with a formula to assist with a worksheet.
On SHEET 1, I have two relevant columns 'ID' and 'DATE'. For example -
<colgroup><col><col></colgroup><tbody>
ID
Date
465260
16/08/18
465260
03/09/18
465260
04/09/18
2859809
20/09/18
2859809
21/09/18...