Microsoft Office Forums - View Single Post - [Solved] Formulas exceeding 8192 characters

Thread: [Solved] Formulas exceeding 8192 characters

View Single Post

Old

11-10-2022, 02:27 PM

Steve Kunkel Steve Kunkel is offline

Steve Kunkel is offline

Steve Kunkel uses Windows 10

Windows 10 Steve Kunkel uses Office 2019

Steve Kunkel uses Office 2019

Office 2019

Advanced Beginner

Join Date: May 2019

Location: Seattle area

Posts: 81

Steve Kunkel is on a distinguished road

Default

Re #4: I make extensive use of helper columns. Some of my workbooks have entire "helper sheets" that stay hidden.

Another idea for shortening formulas: If there are a bunch of repetitive parts, you might be able to make use of the =LET() function.

Reply With Quote