How many of these do you use?
TAKE, HSTACK, XLOOKUP, SEQUENCE, UNIQUE, FILTER, VSTACK, SORTBY, ROWS, LAMBDA
Last week Oz du Soleil shared a video of me solving a challenge with Power Query
I wanted to see if I could do it with just formulas - no Power Query!
https://youtu.be/FIcxyLqzWcE?si=GuCgaSXTNIig6Usu
excel
