Extract list of unique Month & Year from list of Dates

[BKGLTS]

Hello,

I need help please.
I have a list of random dates across multiple years in cells B3:B10.
I am trying to create another list in column D that looks at the list in column B and pulls out only the unique Month and Year combinations represented in the column B list.

I found this formula online and it works when placed in cell D3 and dragged down, but the results populate in Descending order from top to bottom, and I need it to populate in Ascending order from top to bottom.
=TEXT(LOOKUP(2,1/(COUNTIF($D$2:D2,TEXT($B$3:$B$10,"MMM-yyyy"))=0),$B$3:$B$10),"MMM-yyyy")

Can someone please modify this formula to achieve the desired result?

Thank you,
B

 

[Aladin Akyurek]

In D1 control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(ISNUMBER(B3:B10),B3:B10-DAY(B3:B10)+1),B3:B10-DAY(B3:B10)+1),1))

In D2 enter #MonthYear Values#

In D3 control+shift+enter, not just enter, and copy down:

=IF(ROWS($D$3:D3)>$D$1,"",MIN(IF(ISNUMBER($B$3:$B$10),IF(ISNA(MATCH($B$3:$B$10-DAY($B$3:$B$10)+1,$D$2:D2,0)),$B$3:$B$10-DAY($B$3:$B$10)+1))))

 

[BKGLTS]

Thank you Aladin!
This appears to work perfectly.
I substituted the $D$1 in your second formula with your first formula to reduce the need for anything in D1.

 

[Aladin Akyurek]

Thank you Aladin!
This appears to work perfectly.
I substituted the $D$1 in your second formula with your first formula to reduce the need for anything in D1.

You are welcome.