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?
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?