We need a /c/MuseumOfLemmy to preserve this treasure in so that it may be cherished and studied by our children and our children’s children and many generations beyond.
Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works 😫
Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)
Just started a new job two weeks ago, all they use is Excel and Access. Now you’ve got me scared, first job out of uni and feels like a lot of pressure.
Removed by mod
We need a /c/MuseumOfLemmy to preserve this treasure in so that it may be cherished and studied by our children and our children’s children and many generations beyond.
Removed by mod
This is art
I am laughing about how after 7 years nobody has locked the sheets that run the business to avoid this specific thing.
Or maybe they were kocked and the team leader unlocked it so they could break it without saving a backup.
There’s no way they’re using xlookup at year 7. You can pry my index match from my cold dead hands.
Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works 😫
I should probably learn how BI works, but I’m mostly torturing excel to do things it was never intended to do.
Also I do a lot of lookups and xlookup will slow my sheet down.
Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)
Removed by mod
Why isn’t that “Merge Cells” button hidden behind 3 levels of menus up to this day?
🏅
Damn you just described my role but everything happened within a span of 3 years
The ending was great. Nice payoff.
Damn as somebody with very little coding or IT background whatsoever but had to learn excel on my last 5 year of work, I understood it all.
Especially the cell merging… Spawn of the devil itself…
Still power query is quite addictive, the main reason why moving to OpenOffice is hard.
!LemmySilver
This comment should be UNESCO world heritage
*cue
Just started a new job two weeks ago, all they use is Excel and Access. Now you’ve got me scared, first job out of uni and feels like a lot of pressure.
Removed by mod
I guess I’m just about at the end. How the fuck do I use access?
deleted by creator