Repeat Dynamic Array Formula (Unique) in Same Column

[chinkson]

Hi Everyone,

This is my first post and I could really use some help. I have a list of dates (some repeating) and I am using the UNIQUE function to extract the unique dates. I am able to use this successfully. So as you can see in the attachment, I have 3 unique dates and excel has successfully identified them (highlighted).

However, I would like to have the function repeated twice. In other words, after the first set of unique dates are extracted, another identical list of unique dates are appended to the existing list in the same column like the in the image.

So, for example, if there are 5 unique dates, I want excel to give me the same 5 dates twice, one following the other.

I know this seems like an odd request but is there some formula that can do this?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(u,UNIQUE(FILTER(A1:A24,A1:A24<>"")),INDEX(u,SEQUENCE(ROWS(u),,,0.5)))

 

[Fluff]

Another option to match your image

=LET(u,UNIQUE(FILTER(A1:A24,A1:A24<>"")),r,ROWS(u),INDEX(u,MOD(SEQUENCE(r*2,,0),r)+1))

 

[chinkson]

Hi & welcome to MrExcel.
How about

=LET(u,UNIQUE(FILTER(A1:A24,A1:A24<>"")),INDEX(u,SEQUENCE(ROWS(u),,,0.5)))

Hello, thank you for your assistance and prompt response. Unfortunately, I am not getting the formula to work. This is the result I get when I use it.

 

[chinkson]

Another option to match your image

=LET(u,UNIQUE(FILTER(A1:A24,A1:A24<>"")),r,ROWS(u),INDEX(u,MOD(SEQUENCE(r*2,,0),r)+1))

Apologies, I was hasty in my reply. Your solution works, thank you very much. You guys are awesome!

 

[Fluff]

You're welcome & thanks for the feedback.