Produce list of months/year from list

[redspanna]

Hey all

Is there any formula or VB code that can look down the list of dates in column A and produce a dynamic list in oldest to newest order?

NDA.v6.xlsm
	A	B	C
1	DATE
2	01-Jan-20
3	03-Feb-20		January 2020
4	09-Feb-20		February 2020
5	20-Mar-20		March 2020
6	23-Mar-20		April 2020
7	04-Apr-20		January 2021
8	09-Apr-20		February 2021
9	05-Jan-21		September 2021
10	09-Feb-21		February 2022
11	11-Feb-21
12	17-Sep-21
13	03-Feb-22
Data (2)

The required result shown in column c

 

[Rick Rothstein]

@Peter_SSs... As I indicated, I came late to the thread and wasn't sure where it was currently, but I did notice no one had taken advantage of XL365's ability to spill data, so I figured I would post the formula I did and figured you (or someone else) would pick up on it and clean it up for wherever the thread was at currently... and you did.

 

[Peter_SSs]

but I did notice no one had taken advantage of XL365's ability to spill data,

You weren't to know, but that information only became available some time after post #17.
Up until that time the OP's version was shown as 2016, hence the type of formulas being suggested to that point.