Forum Discussion
Extract Functions from a Formula
Hello, I often go to the Excel BI Challenges on linked in. I have started my own spreadsheet that I use as a reference. Anyway, what I do is take one of the formulas that has been given in the comm...
I'm still very much a noob with REGEX so there is probably a better way than my hybrid approach...
=TEXTJOIN(", ",1,SORT(UNIQUE(SUBSTITUTE(REGEXEXTRACT(A1,"[A-Z]+\(",1,0),"(","")),,,1))and for the Bonus question,
there may be only 1arguement but the DROP(n,i) is an array and therefor m<DROP(n,i) will still be an array in most cases and hence the need for the AND