Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Excel Array formulas: find the latest common year

Nov 6, 2011 7:33PM PST

Hi everybody,
I have three time series each with the same 100 countries but of different length depending on the country.

Discussion is locked

- Collapse -
Clarification Request
Data Sort
Nov 6, 2011 7:44PM PST

Have you tried using Data sort?

- Collapse -
Answer
Re: Excel
Nov 6, 2011 8:00PM PST

To me, this seems more like a database (SQL) problem than an Excel problem. So maybe Excel is just the wrong tool to do it.

Kees