Another way is to redesign your spreadsheet. I take it you
have a spreadsheet which contains monthly data in columns
and you want to know the result of the last entered month.

As you are entering the new month's data to the right of all
other data you have to "find" which column you have used
for that month. If you enter this months data into column B
(or the first column after the row titles), then you can use
column B for your formula cos that is always where the last
month's data will be. All you need to do it select one cell
on the current last month's data and, using menus, select
Insert -- Row.

To make sure your formula does not refer to the column to the
right of the one you just entered you need to make it an indirect
formula like this.

= INDIRECT("B15") + F15

If you actually want this formula in all cells in the column then
a more general one would be

= INDIRECT("B:B") + F:F

That would add the data in the current row for the current month
(column B) to the data in the current row in column F.

The other advantage in doing it this way is that you only need to print
one page to get the latest data and it will always be the first page. This
assumes that all the rows for this month can fit on one page. It saves
working out how many pages you need to skip as your get more and
more months added and thus a wider and wider spreadsheet.

Steve.



"Bob Phillips" wrote in message ...
Ron,

Good point!

Bob

"Ron Rosenfeld" wrote in message
...
On Tue, 02 Dec 2003 14:56:11 GMT, "Excelwiz wanabee"
wrote:

Hi,

I'm wondering if ya'll excel "wizards" can help me out. I want to be able
to
get the "last entered" value for a particular row and subtract from it a
fixed field (i.e. L15-F15 where L15 is the last entered value (or G15,
H15,
etc.; increments monthly) and F15 is a field that does not change in the
equation.)

Thanks,

Bill



If there are no "blanks" then Bob Philips worksheet formula will work
fine. If
there may be blanks in the row, then the *array-entered* formula:

=F15-OFFSET(A15,0,-1+MAX(ISNUMBER(15:15)*COLUMN(1:256)))

should subtract from F15 the last numeric entry in Row 15.

To array-enter a formula, hold down <ctrl<shift while hitting <enter.
XL
will place braces {...} around the formula.


--ron