131
For all the corporate Excel jockeys out there
(lemmy.world)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 30 Apr 2024
131 points (98.5% liked)
Vanity license plates
376 readers
1 users here now
A place to post pictures of vanity and customized license plates that you see around town. For more info, check out this Wikipedia page.
Rules:
- Posts must be OC photos of customized/vanity license plates.
- Post titles can be jokes or transcriptions of the plate text.
- No driver doxxing.
- No bots.
- Be nice.
founded 1 year ago
MODERATORS
XLOOKUP is where it's at.
I've been a loyal adherent of the great INDEX(MATCH) for years, but I will have to look at this XLOOKUP deity to see if I should convert.
FILTER is another of the more recent excel functions that is also really awesome
I use FILTER and XLOOKUP on the daily
Sad, that's what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
I know that XLOOKUP is probably better, but I just like my lil INDEX(MATCH) for some reason. You couldn't pay me to convert (you probably could)
INDEX(MATCH)
It’s clunky but the best without bricking older Excel users
Fuck yeah it is. Even better than the tried and tested INDEX MATCH combo