Jeez! Made me think ;o)

I now understand way more about the row() function, the sumproduct()
function and arrays. thx.

"Ron Rosenfeld" wrote:


If you want to return a 1 or a 0, depending on if there is a capital letter,
versus anything else, you could use this formula also:

=SUMPRODUCT(--EXACT(A1,CHAR(ROW($65:$90))))


--ron