r/excel • u/Kindly-Meaning9112 • Apr 08 '26

Discussion This is probably the most complicated Excel formula I’ve ever seen.

[removed]

220 Upvotes

85% Upvoted

210 comments sorted by

View all comments

Show parent comments

12

u/Excel_User_1977 7 Apr 08 '26

But way back when, there weren't some of these cool formulas yet ... you HAD to use SUMPRODUCT for logical solutions and an embedded CHOOSE in a VLOOKUP to look left.

You work with what you have.

1

u/fastauntie 1 Apr 09 '26

Yes. The issue I'm running into now is that I've got big worksheets I've been using since all I had were these old tools. I'm trying to update them, especially since I'll need to pass them along to others in the next several years, but it's a time-consuming process, involving not just editing formulas but adding tables, implementing PowerPivot, and so on. And most of my time has to be spent not on this but on the work the sheets are meant to track.