So the array formula would only give a result of blank or "colors". How do I get it to return (1) blank if all cells are blank, (2) the word "color" if there is only text in one cell, and (3) "colors" if there is text in more than one cell?
And I don't want to limit the kind of text that can be in cells A1:A50 to just different colors. In other words, if there is ANY text in cells A1:A50, that counts.
Bookmarks