this post was submitted on 18 Aug 2026
200 points (99.0% liked)
People Twitter
10346 readers
2004 users here now
People tweeting stuff. We allow tweets from anyone.
RULES:
- Mark NSFW content.
- No doxxing people.
- Must be a pic of the tweet or similar. No direct links to the tweet.
- No international politcs
- Be excellent to each other.
- Provide an archived link to the tweet (or similar) being shown if it's a major celebrity, figure or any politician. If you replace the "x" at their site with xcancel (so it beomes xcancel.com), and you're not on mobile, it will save video. https://web.archive.org/save is another great option. Archive.is is no longer recommended because they remove/alter content.
- If a tweet (or similar) makes a statement of fact, either mark it as "satire" in the body or provide the original source link backing up the statement
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
"So you do vlookup like this and then drag it down to autofill."
"ππ π ππ πππ π¬"
xlookup rather than vlookup - we're not living in the Ubaid period.
Ah, the Index/Match technique, I haven't used this one since Heian era
Kind of unrelated, but a coworker shared a spreadsheet with me the other day, and instead of dragging down to autocomplete the row number or using ctrl+d, he wrote a β1β then βA1+1β and dragged that down. It kept breaking because the rows had to be rearranged, and if you initially highlighted a modified row before dragging it would propagate the error down.
Youβre an engineer, damnit.
It's a valid method that avoids some edge cases where Excel's autocomplete gets confused. He just forgot the last step of copy and then paste back into the same cells as text to remove the formula.
My pet peeve is my coworker who finds it easier to write macros to analyze the data instead of setting up formulas, and then I am completely unable to follow his analysis logic because it's all just columns of numbers with no way to tell what was used to calculate what.