Forum Discussion
Solved
Formulas in excel for items uploaded to Google
We have been using the sheet in the link on our google drive but we are having ongoing issues with the formula erroring. The sheet is not working again now but did work for several years. Often I c...
work in excel on my desktop but once I drag them to our Google Drive
'cause GS is not Excel:
EY
A3=IFNA(ARRAYFORMULA(FILTER('All Stu - Alpha'!C3:I,REGEXMATCH('All Stu - Alpha'!E3:E, "EY1|EY2|EY3|EY4"))))
Bye
work in excel on my desktop but once I drag them to our Google Drive
'cause GS is not Excel:
EY
A3
=IFNA(ARRAYFORMULA(FILTER('All Stu - Alpha'!C3:I,REGEXMATCH('All Stu - Alpha'!E3:E, "EY1|EY2|EY3|EY4"))))
Bye
Thanks so much Terio, worked perfectly. Appreciate your time
Thanks you for reply
