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