troubleshooting Question

Dynamic Arrays: Combine two date lists?

Avatar of Anthony Mellor
Anthony MellorFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft OfficeMicrosoft Excel
17 Comments1 Solution24 ViewsLast Modified:
Example file:
LDATELISTSCOMBINE_EE.xlsx

We have date list one extracted by DA from source list.
I have date list two, residing in its own source sheet (same file) and I wish to combine it with the above list.

I am not sure if I want each date unique, so that option will be nice.
I desire DA solutions only, please as these source lists constantly change in length and content.

Is this easy? Been doing my head in. Must be, but I can't see it.

Is there a wider context? erm. This is for listing two sets of transactions, one from the past but future dated  (unpaid balances) and one from the future (so recurring bank transactions not yet incurred) All dates are future dates. So that's the bones of a cashflow expectation report.

MMULT? Needs identical arrays I think
Sumproduct?
I suppose my basic question is how to combine two 1 dimensional different length dates arrays? I think - or try to.
Why do I think SEQUENCE might be involved?

Anthony


DA=Dynamic Array




Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 17 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros