I'm entering data everyday and want to use the newest data with out changing
the fromula everyday

And what formula would that be?

--
Rick (MVP - Excel)


"Mel" wrote in message
...
I'm entering data everyday and want to use the newest data with out
changing
the fromula everyday

If you are entering values in Col A and want to refer to the last entry in
Col A then use this in your formula

=LOOKUP(2,1/(A:A<0),A:A)

"Mel" wrote:

I'm entering data everyday and want to use the newest data with out changing
the fromula everyday

=LOOKUP(2,1/(A:A<0),A:A)

In Excel versions prior to Excel 2007 you can't use an expression that
manipultes an entire column like this:

1/(A:A<0)

You'd have to use a smaller range.

--
Biff
Microsoft Excel MVP


"Sheeloo" <Click on my name above to get instructions for getting my email
id wrote in message
...
If you are entering values in Col A and want to refer to the last entry in
Col A then use this in your formula

=LOOKUP(2,1/(A:A<0),A:A)

"Mel" wrote:

I'm entering data everyday and want to use the newest data with out
changing
the fromula everyday

Hi Mel,
Maybe something like this, where the last value in column A is added to the
value in B1 and where 9^9 is a very large number and greater than any you
would have in column A. If you knew that you would never have a number
larger than say 500, you could replace 9^9 with 500.

=LOOKUP(9^9,A:A)+B1

HTH
Regards,
Howard

"Mel" wrote in message
...
I'm entering data everyday and want to use the newest data with out
changing
the fromula everyday