Usign the =sort function in a Dynamic Array to sort by Month

[WxShady13]

I have a dynamic array that is pulling month (i.e. Jan, Feb, Mar, etc.) from a table. I need to be able to sort the dynamic array so the month's align correctly (i.e. Jan, Feb, Mar, Apr, etc.) in the Data Validation dropdown field automatically.

My formula for the array is =Unique(LOA[Month]) and I know I can use the =sort formula around it but I cannot make it sort properly. I have created a helper table listed below to try and help the formula but it still just gives me #VALUE.

Month	Month #
Jan	1​
Feb	2​
Mar	3​
Apr	4​
May	5​
Jun	6​
Jul	7​
Aug	8​
Sep	9​
Oct	10​
Nov	11​
Dec	12​

 

[Fluff]

How about

=UNIQUE(SORTBY(LOA[Month],MONTH("1/"&LOA[Month]))

 

[WxShady13]

How about

=UNIQUE(SORTBY(LOA[Month],MONTH("1/"&LOA[Month]))

THANK YOU!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.