[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.