Hi everybody,
I am working on the following problem and seemed to get stuck.
My table contains the following information
# Date Text 20/0001 01.01.2020 Sample text 20/0002 17.01.2020 Sample text 19/0001 22.12.2019 Sample text 19/0002 28.12.2019 Sample text 20/0003 22.12.2020 Sample text
In a nutshell, I am trying to build a incrementally increasing number in Column A based on the logic that:
If a date is within the same year, increase the number in column by 1.
Thanks everyone for your help in advance.
Best regards,
Maxim
Bookmarks