Feb 05 2019 01:58 PM
Feb 05 2019 11:11 PM
Feb 15 2019 09:40 PM
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.