Summarise the date by month
I have a list of dates in ascending order.
In another column, I want to summarise the dates according to month, but
only for the first instance of that month, i.e. for the first Jan date
listed, I want the adjacent cell to show 'January', but I don't want the word
'January' to show for all Jan dates.
Any ideas?
|