M
Mel
I'm entering data everyday and want to use the newest data with out changing
the fromula everyday
the fromula everyday
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
And what formula would that be?
S
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)
Col A then use this in your formula
=LOOKUP(2,1/(A:A<>0),A:A)
L
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
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
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
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