Cell offset issue
 

HI,

I am trying to have a row that references cells that are moving 1 down and 1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks

Cell offset issue
 

Enter this formula in A6 and copy across:

=LOOKUP(1E100,A1:A5)

--
Biff
Microsoft Excel MVP


"MGarrison" wrote in message
...
HI,

I am trying to have a row that references cells that are moving 1 down and
1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks

Cell offset issue
 

TY.

What doe the 1e100 mean?

"MGarrison" wrote:

HI,

I am trying to have a row that references cells that are moving 1 down and 1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks

Cell offset issue
 

1E100 means 10 to the power of 100, or 1 followed by 100 zeroes, in other
words, a large number.

More generally, 1.2345E67 means 1.2345 multiplied by (10 to the power of 67)
or in Excel terms =1.2345*10^67
--
David Biddulph

"MGarrison" wrote in message
...
TY.

What doe the 1e100 mean?

"MGarrison" wrote:

HI,

I am trying to have a row that references cells that are moving 1 down
and 1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks