Formula follows the most recent entry in a column???
Thank You Ron,
This works like a charm. After reading the description of the lookup
command I can understand the concept you are using. However, I can't quite
figure out why you chose the "10^99" argument. If you get a chance to share
that info with me I'd appreciate it.
Also, your other suggestion did not achieve what I was hoping for but after
re-reading my question, I clearly did not provide exactly what I was trying
to do.
Thanks again for your help.
Larry
"Ron Coderre" wrote:
Try something like this:
B32: =LOOKUP(10^99,A:A)
That formula returns that last numeric entry in Col_A
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP-Pro
"lb303910" wrote:
I have a simple formula =sum(a16), that I use to collect data from cell A16
and place it in cell B32. If I were to add data to A17 (and eventually A18,
A19, A20, etc.) how would I structure a formula to automatically collect the
data from the next cell every time I make a new entry and place that data in
B32 without rewriting the original formula each time to specify the next cell?
Thanks in advance for your help.
lb303910
|