Ptownbunker
New Member
- Joined
- Jul 14, 2018
- Messages
- 1
Is there an app or website to automatically search a formula and condense it if possible? I have a formula that when pasted into Google docs, takes up 14 pages. The formula runs about 75 times on my spreadsheet, and even though it functions as it should, changing a reference value makes for a pretty slow change in the instances of the formula, so I’d like to shorten it if possible. Searching the formula for repetition manually would be almost impossible. Does anyone know of an app like this?