A much better way to manage Excel formulas

Topic

New Reply

MICROSOFT 365 By Peter Deegan Excel’s Advanced Formula Environment (AFE) is something that, once you get it, you will wonder how you lived without it.
[See the full post at: A much better way to manage Excel formulas]

8 users thanked author for this post.

Patricia Grace, AlexEiffel, fisher75, WCHS, RetiredGeek, bamfordL, rbailin, Norio

Reply | Quote

Replies

I love Excel, but I’m not the only one that doesn’t understand my own formulas. The first one I tried AFE’s debug feature on crashed the debugger. My worksheet tracks monthly values and dates of my IRA. This formula correctly shows the date of the highest value recorded. I just don’t know how it works. I had even put a note on the formula after I tried valiantly to get it:

This formula is magic. I have tried to break it down and explain it visibly.

What makes this formula so difficult and “magic” is that standing alone the innermost OFFSET function returns #VALUE!, yet it can still be used successfully inside the MATCH formula!

Replies should be in short, 6th grade level sentences, please.

Reply | Quote

Says no longer supported (Windows 10 / Excel 2019)

Reply | Quote

I still use Excel 2003 because I like menus (I can use the keyboard), not toolbars.  Is AFE available for it?  (I do see the post above that says it’s not supported on an even later version).

Reply | Quote

Excel 2003 is definitely not supported for the AFE.

Peter Deegan
Office-Watch.com

Reply | Quote

sounds interesting.  Might even have gotten me to start using formulas in excel.  However, like most things MS, I can’t get it to install(?), can’t find it.  Get error messages about changing privacy settings, which I did and made no difference.,  instruction about finding the addin under insert>my add-ins,  but, of course, no my add-in section in the insert tab.  etc, etc.

seemed like an intriguing idea,  but I’ve run out of time for dealing with it.

Reply | Quote

Too bad that’s not available in Windows 10. I often have trouble getting my brackets to match up. So, I work it out, using Word to break up the formula into lines and apply colors to show the bracket span, but it’s all done in text and is useful only for eyeballing. It would be nice if some of this were automatic.

Reply | Quote

The library does not load into Excel 2019 on Windows 10.
I mostly edit the formulas in the cell with Alt-Enter for newlines and spaces for indentation in order to make them readable.  AFE would have saved much time if it worked.

1 user thanked author for this post.

Peter Deegan

Reply | Quote