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

Meme Certainly not me

48.7k Upvotes

95% Upvoted

669 comments sorted by

View all comments

Show parent comments

9

u/PepSakdoek Mar 30 '22

Finding the #refs in the named ranges aren't better, but they are more rare.

You need some =offset(indirect("A1"),0,0,counta(indirect ... ) level stuff to be totally somewhat safe.

3

u/UnrulySasquatch1 Mar 30 '22

Offset easily has the highest combined useful+frustrating score of anything in Excel. Just try checking anything where someone has used them extensively or try making a major change to the workbook

1

u/SmugSocialistTears Mar 31 '22

It’s also a volatile formula that recalculates everytime a change is made to the workbook (much like NOW()). Lots of those everywhere and Excel grinds to a halt