Twerppoet, you posted this formula;
I types this in exactly and this is what it says;
The operator "-" expects a number, date, or duration but found "C2."
What am I doing wrong?
EDIT, See post below.
Last edited by Jmfocus; 08-30-2011 at 07:19 PM.
Give Raymond's method a try instead. Maybe it won't break when using Form entries.
This is really annoying! No reason for it to happen.
Thanks to both of you for your help with this problem. I had been working on this for a couple weeks.
Actually every time I enter a new line, form or not, the formula bugs out. It's as if LOOKUP returns zero until I refresh the formula.
I'm trying variations, but this looks like a major bug in LOOKUP. Sigh
Ok, I've managed to put together a different approach MATCH, MAX, and other arcane reference functions. It's at least as complicated as my worst before, but I've tested it and it works with forms, and does not use cell ranges to work.
If you want it, I'll try to describe the creation. If you've decided to use Raymond's method instead (and if I were not so stubborn I'd have just done that myself), I won't go to the trouble of typing it out.
Here is the text version, and the screen shot for reference.
C2-INDIRECT(ADDRESS(MATCH(MAX(DateColumn),DateColumn, find value),3,neither preserved))
Let me know.
too cool! pls post the file. i'd like to see it. thanks!
iPad2 3G 64GB