Need data result in last cell of array that contains blank cells
 

Example:

A1=200
B1=300
C1=400
D1=[blank]
E1=[blank]
F1=[blank]
G1=(last cell from above that contains data...i.e. C1)

I'm a bit of an Excel novice so could really use a little help.

Thanks!

Need data result in last cell of array that contains blank cells
 

Assuming that range will only contain numbers,
try something like this:

=LOOKUP(10^99,A1:F1)

or...if you want to avoid an error when there are no numbers:
=IF(COUNT(A1:F1),LOOKUP(10^99,A1:F1),"")

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"smesurfer" wrote:

Example:

A1=200
B1=300
C1=400
D1=[blank]
E1=[blank]
F1=[blank]
G1=(last cell from above that contains data...i.e. C1)

I'm a bit of an Excel novice so could really use a little help.

Thanks!

Need data result in last cell of array that contains blank cel
 

Ron, your first recommendation worked perfectly.

THANK YOU!

"Ron Coderre" wrote:

Assuming that range will only contain numbers,
try something like this:

=LOOKUP(10^99,A1:F1)

or...if you want to avoid an error when there are no numbers:
=IF(COUNT(A1:F1),LOOKUP(10^99,A1:F1),"")

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"smesurfer" wrote:

Example:

A1=200
B1=300
C1=400
D1=[blank]
E1=[blank]
F1=[blank]
G1=(last cell from above that contains data...i.e. C1)

I'm a bit of an Excel novice so could really use a little help.

Thanks!