Oct 19 2020 11:37 AM
Hello! I have a spreadsheet I am having brain fog getting a formula. In the attached image in cell D2, I need a formula that will result in FALSE if the range E2:K2 shows numbers in any of the cells and TRUE if the range E2:K2 shows any text. Any help is much appreciated!
Oct 19 2020 12:45 PM
In D2:
=ISERROR(--CONCAT(E2:K2))
or as an array formula confirmed with Ctrl+Shift+Enter:
=OR(ISTEXT(E2:K2))
Fill down.