Referring to last row with data in it
On Oct 15, 11:21*pm, Mike H wrote:
Hi,
I may be missing something here but on the assumption dates are entered
sequentially in column A don't you really want the last value in Column C
regardless of date.
Yep
if so try this
=LOOKUP(10^23,'ANZ Bank Statement'!C:C)
Now if someone has more than 10^23 dollars/pounds in the account this fails :)
It worked. Thanks. Now I'm curious about *why* that worked!?
Travis
|