[cm2187]

20 years overdue...

Another one that is massively overdue: take multiple arrays as arguments and return the distinct values, sorted (kind of like the remove duplicate button, but that doesn't require to click a button). [edit] actually it was introduced in 2021 ("UNIQUE" function)

Also take multiple arrays and returns the values that are in common (like an inner join). Use case: you want to align two time series by creating a 3rd time series made of the dates common to both original time series.

Then you can have all sort of finance related function. Validate the checksum for an ISIN, CUSIP, SEDOL, etc.

Excel should also come with the most common holiday list (all the major cities at least).

[WastingMyTime89]

> Also take multiple arrays and returns the values that are in common (like an inner join). Use case: you want to align two time series by creating a 3rd time series made of the dates common to both original time series.

You just have to add a column and you are an XLOOKUP and a quick filtering away from the result you want. It’s a fairly common operation.

> Excel should also come with the most common holiday list (all the major cities at least).

It’s the same. You just have to add a table and do a lookup.

[cm2187]

> You just have to add a column and you are an XLOOKUP and a quick filtering away from the result you want. It’s a fairly common operation.

Yeah you can do that by introducing multiple columns or creating a VBA UDF. My point isn’t that it cannot be done (like TEXTSPLIT or XLOOKUP, there were more convoluted ways to do that already). It’s more that it is something common enough that there should be a simpke function for that.

On the holiday lists I mean the list of bank holidays by major city. I believe right now you need to provide that yourself, but it is something microsoft could build and maintain centrally instead of everyone reinventing the wheel. They do that for timezones/time change in the OS already.

[WastingMyTime89]

Yes, I get what you mean. I was very happy to replace 90% of my use of convoluted EQUIV MATCH with XLOOKUP. Sometimes new functions are great.

The point I wanted to make is that sometimes you can just get results quickly by some manual manipulation like sorting in complement to formula.