Hacker News new | ask | show | jobs
by WastingMyTime89 1382 days ago
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.