find value of first cell in range containing uppercase chracter

[EJT54]

Hi there,

I'm looking for a way to find the value of the first cell in a range that contains an uppercase character. So it should give 'B' for a range of "a,c,d,a,B,c,a" and D for a range of "c,c,a,a,a,a,D". A solution without VBA would be preferred

Thanks in advance,

Erik

 

[sheetspread]

Excel 2010
	A	B
1	q
2	w
3	e
4	r
5	t
6	Y
7	u
8	j
9	O
10	p
11	A
12
13		Y
Sheet7

Cell Formulas
Range	Formula
B13	{=INDEX($A$1:$A$11,MATCH(1,IF(CODE($A$1:$A$11)>=65,IF(CODE($A$1:$A$11)<=90,1)),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[EJT54]

Thanks sheetspread! Exactly what I needed.