Hello dear excel enthusiasts!
I have Sheet1(A3:C13), need formula to find any text values or even single letter in column A3:A13, to show me one answer or more, exp. {" ","4"," ","6"...}, then I need to format those rows. If answer is rows4&6, please dear excel fill with red colour rows 4&6 through A4:C4 and A6:C6. Column A is usually empty, sometimes it will contain some letter(text).
Ps. Suproduct will be nice to have also, to sum values of those red rows(indexB3:C13). Thank You So Much!
MATCH("?*",A3:C13,0)+ROW(A3:C13)-1
IF(("?*"=A3:A13)*1,ROW(A3:A13),"")
{=IF(MATCH(COUNTIFS(a3:a13,"?*"),a3:a13,0),ROWS(a3:a13),"")}
=SUMPRODUCT(INDEX(b3:c13,IF((MATCH("?*",a3:a13,0)=ROW(a3:a13)),ROW(a3:a13),""),))
I have Sheet1(A3:C13), need formula to find any text values or even single letter in column A3:A13, to show me one answer or more, exp. {" ","4"," ","6"...}, then I need to format those rows. If answer is rows4&6, please dear excel fill with red colour rows 4&6 through A4:C4 and A6:C6. Column A is usually empty, sometimes it will contain some letter(text).
Ps. Suproduct will be nice to have also, to sum values of those red rows(indexB3:C13). Thank You So Much!
MATCH("?*",A3:C13,0)+ROW(A3:C13)-1
IF(("?*"=A3:A13)*1,ROW(A3:A13),"")
{=IF(MATCH(COUNTIFS(a3:a13,"?*"),a3:a13,0),ROWS(a3:a13),"")}
=SUMPRODUCT(INDEX(b3:c13,IF((MATCH("?*",a3:a13,0)=ROW(a3:a13)),ROW(a3:a13),""),))