Forum Discussion
shahzad_afzal
Oct 18, 2020Copper Contributor
Retrieving date of only next occurrence
Hi Dear; I have a list of date sorted data with some events happening multiple times... Example; Customer ABC12345678 doing purchase with us occasionally... from the last purchase date and till tod...
Riny_van_Eekelen
Oct 18, 2020Platinum Contributor
shahzad_afzal Assuming your list is sorted by date (ascending) and if your Excel version supports XLOOKUP, please find a possible solution in the attached workbook.