Excel Formula Character Limit

Copper Contributor
I am trying to use a formula that is more than the maximum formula character limit. For obvious reasons it won’t work. Does anyone have a method to get around this? The formula I am trying to use is around 61,000 characters long. Unfortunately there is no other known way to produce the outcome I am trying to achieve without this formula. Can anyone help?
2 Replies
Hello! I am shure that someone here as @Sergej Balkan can help to shorten down your formula. Give hin pls a pm. Greets, Eva

I know these 2 ways to shorten a long formula: 

1. Split the formula into separate columns; or 

2. Use named formulas for the intermediate

solutions. 

Please upload your sample file so that I can give it a try.