use the last entry in a column in a formula

[Mel]

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

 

[Rick Rothstein]

And what formula would that be?

 

[Sheeloo]

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)

 

[L. Howard Kittle]

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

 

[T. Valko]

=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