Find Last Numeric Cell Using Formulas

[parry]

How can you obtain the address of the last numeric cell in a range by using formulas? In the following example the last numeric cell in row 1 is E1. Cell F1 contains a formula which returns "" and is treated as text as per the type formula shown. Ctrl-RightArrow from cell A1 returns F1 as the last used cell in the row.

I can do this with a custom function or sub but how about a formula?
I have tried =ADDRESS(1,COUNTA(1:1)) but this returns cell F1. Any ideas?

Tammy.xls
	A	B	C	D	E	F	G
1	12	22	13		34
2	12	22	13		34
3
4		TypevalueofcellF1		2	(Text)
5		LastCellusingCountA		$F$1
6
Sheet1

 

[KrisLB]

What about if I was wanting to find the first numeric cell in a range of addresses? How does the formula change?

 

[Aladin Akyurek]

What about if I was wanting to find the first numeric cell in a range of addresses? How does the formula change?

=INDEX(Range,MATCH(TRUE,ISNUMBER(Range),0))

which needs to be confirmed with control+shift+enter, not just enter.

This returns the first numeric value from Range.

Note that Range must be a vector, not a matrix, for this formula to work. Also, Range cannot be a whole column like A:A.

 

[KrisLB]

What about if I was wanting to find the first numeric cell in a range of addresses? How does the formula change?

=INDEX(Range,MATCH(TRUE,ISNUMBER(Range),0))

which needs to be confirmed with control+shift+enter, not just enter.

This returns the first numeric value from Range.

Note that Range must be a vector, not a matrix, for this formula to work. Also, Range cannot be a whole column like A:A.

Aladin, perfect! It is almost frustrating that nothing on this board can stump you. Works like a charm - I appreciate the help!!