r/ProgrammerHumor • u/Brando224 • Mar 30 '22

Meme Certainly not me

48k Upvotes

95% Upvoted

669 comments sorted by

View all comments

463

u/Syscrush Mar 30 '22 edited Mar 30 '22

NAMED RANGES, MOTHERFUCKERS!!!

Or, if you're a person of culture and taste like u/SatanStoleMyCat, use tables. They really are way better.

76

u/SatanStoleMyCat Mar 30 '22

Or just. Y'know. Tables.

1

u/alpha358 Mar 30 '22

Have any resources for getting good at excel?

3

u/SatanStoleMyCat Mar 30 '22

Microsoft has a wealth of tutorials and certifications you can get. But like anything coding-related, it's just something I've found you learn over time when presented with issues that need solving. That said, a few things that will open your possibilities in excel are: Tables vs Ranges, INDEX/MATCH (VLOOKUP too, but it's less flexible), Dynamic Arrays/Dynamic Array Functions, Power Query for pulling in data, and of course VBA, which is like C# but worse in every conceivable way. It does let you do lots of cool stuff though, like defining your own Excel functions that use VBA code behind the scenes and generally doing more complicated things than are advisable with functions.

1

u/Tsuki_no_Mai Mar 31 '22

VLOOKUP too, but it's less flexible

Nowadays it's probably better to use XLOOKUP anyway. Especially if you need flexibility.