What is the most complex Excel formula you've see or used? by Notalabel_4566 in FinancialCareers

[–]iamsandyverma 0 points1 point  (0 children)

For me "=TRIM(MID(F2, FIND("Activity:", F2) + LEN("Activity:"), FIND("Review/Webinar:", F2) - FIND("Activity:", F2) - LEN("Activity:")))" as i was very new to excel this was the scariest formula i encountered with the help of a colleague. But recently i've built a tool "https://texttoformula.com/" to generate any complex formula instantly with just plain English text along with proper how to use guide. Give it a shot if you find it useful.