Tom, that appears to work! And I looked at the MATCH function but am unsure
as to the purpose of values you entered for that function; can you explain
why the 9.9999... ?

Thanks,

Bill

"Tom Ogilvy" wrote in message
...
=INDEX(G15:AB15,1,MATCH(9.99999999999999E+307,G15: AB15,1))-F15

--
Regards,
Tom Ogilvy



"Excelwiz wanabee" wrote in message
.. .
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