range, cell refrence, but with a new twist
 

Using excel 2007. I have a range consisting of "X" cells (monthly total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month, the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the last
date recorded.

Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?

--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.

range, cell refrence, but with a new twist
 

It's not real clear what you want. You want the last value entered but you
don't say where to look for it so here's my best guess:

A1:J1 = dates
A2:J2 = some data

Return the value from A2:J2 that corresponds to the last date entered in
A1:J1

=INDEX(A2:J2,MATCH(10^10,A1:J1))

--
Biff
Microsoft Excel MVP


"buzz" wrote in message
...
Using excel 2007. I have a range consisting of "X" cells (monthly total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month,
the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the
last
date recorded.

Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?

--
Seamen, with their inherent sense of order, service, and discipline,
should
really be running the world.

range, cell refrence, but with a new twist
 

try this for row 1
=INDEX(1:1,MAX(COLUMN(1:256)*(1:1<"")))
or for col A
=INDEX(A1:A65000,MAX(ROW(1:65000)*(A1:A65000<"")) )
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"buzz" wrote in message
...
Using excel 2007. I have a range consisting of "X" cells (monthly total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month,
the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the
last
date recorded.

Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?

--
Seamen, with their inherent sense of order, service, and discipline,
should
really be running the world.

range, cell refrence, but with a new twist
 

In rereading my question I find I have muddied up the waters by TMI.

What I need is a way to display the results of the LAST VALUED CELL IN A
COLUMN.
The column may/may not have additional following cells.
--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.


"T. Valko" wrote:

It's not real clear what you want. You want the last value entered but you
don't say where to look for it so here's my best guess:

A1:J1 = dates
A2:J2 = some data

Return the value from A2:J2 that corresponds to the last date entered in
A1:J1

=INDEX(A2:J2,MATCH(10^10,A1:J1))

--
Biff
Microsoft Excel MVP


"buzz" wrote in message
...
Using excel 2007. I have a range consisting of "X" cells (monthly total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month,
the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the
last
date recorded.

Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?

--
Seamen, with their inherent sense of order, service, and discipline,
should
really be running the world.

range, cell refrence, but with a new twist
 

Ahhhhh, I manipulated the values and got it to work! I thought there might be
a worksheet function that would give the last valued cell in a coulmn. But
this works fine, now I just have to figure out why. Thanks again.
--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.


"T. Valko" wrote:

It's not real clear what you want. You want the last value entered but you
don't say where to look for it so here's my best guess:

A1:J1 = dates
A2:J2 = some data

Return the value from A2:J2 that corresponds to the last date entered in
A1:J1

=INDEX(A2:J2,MATCH(10^10,A1:J1))

--
Biff
Microsoft Excel MVP


"buzz" wrote in message
...
Using excel 2007. I have a range consisting of "X" cells (monthly total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month,
the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the
last
date recorded.

Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?

--
Seamen, with their inherent sense of order, service, and discipline,
should
really be running the world.

range, cell refrence, but with a new twist
 

There are many ways to reference the last value in a range but the specific
method used depends on several conditions. See this for an in-depth
explanation:

http://xldynamic.com/source/xld.LastValue.html

--
Biff
Microsoft Excel MVP


"buzz" wrote in message
...
Ahhhhh, I manipulated the values and got it to work! I thought there might
be
a worksheet function that would give the last valued cell in a coulmn. But
this works fine, now I just have to figure out why. Thanks again.
--
Seamen, with their inherent sense of order, service, and discipline,
should
really be running the world.


"T. Valko" wrote:

It's not real clear what you want. You want the last value entered but
you
don't say where to look for it so here's my best guess:

A1:J1 = dates
A2:J2 = some data

Return the value from A2:J2 that corresponds to the last date entered in
A1:J1

=INDEX(A2:J2,MATCH(10^10,A1:J1))

--
Biff
Microsoft Excel MVP


"buzz" wrote in message
...
Using excel 2007. I have a range consisting of "X" cells (monthly
total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same
month,
the
dates of which are recorded in the same row, but in a a neighbor
column. I
want to automatically reference ONLY THE LAST CELL corresponding to the
last
date recorded.

Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?

--
Seamen, with their inherent sense of order, service, and discipline,
should
really be running the world.