FILTER UNIQUE FUNCTION

[datastudent]

Hi,

How can I filter months accordingly with unique function?

Income & Expense Tracker.xlsx
	A	B	C
1
2		February
3		March
4		April
5		January
6
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=UNIQUE(TRANSACTIONS[MONTH])
Dynamic array formulas.

 

[SanjayGMusafir]

You have already done that... What Exactly you want to do?

 

[datastudent]

You have already done that... What Exactly you want to do?

January should be at the top.

 

[Fluff]

You mean sort them, rather than filter?
If so how about

Fluff.xlsm
	A	B
1
2	February	January
3	March	February
4	April	March
5	January	April
Sheet5

Cell Formulas
Range	Formula
B2:B5	B2	=LET(u,UNIQUE(A2:A5),SORTBY(u,MONTH("1/"&u)))
Dynamic array formulas.

 

[Joe4]

That is because your current entries are just "Text", and will be sorted in alphabetic order, like all text is.

If you want it to be sorted in date order, you would need to enter valid dates., so it can sort in date order.
For example, you could enter a valid date of 1/1/2024 (in the US) or 2024/1/1 (in Europe), and then format that cell as "mmmm" to get it to show "January".
Then it would be stored as a valid date, and show as "January", and sort the way you want.

Or you can do something like Fluff showed above.