Problem restated:

Users have three columns (months) to post data: C14:C43, F5:F35, and
I5:I34. They post sequentially, starting in cell C14, posting in C15 next,
then C16, etc. After they post in C43 (the last entry for that month), they
move to the next column and post in F5, then F6, etc. Then the move to the
third column and post. The desired formula is this:

($D$4 - LP)
------------------ Where LP is the last posting in the three monthly
columns.
($D$4 - $D$5)


"Leo Heuser" wrote:

"Phil Hageman" skrev i en meddelelse
...
I need a formula: 25 divided by the last number populated in columns
C14:C43, F5:F35, I5:I34. C14 will be the first cell populated, I34 the
last
populated.
--
ph

What exactly do you mean by "last number"?
With data in C14:C23 (C24:C43 blank), F5:F20 (F21:F35 blank),
i5:i22 (i23:i34 blank), which cell holds the last number?
With data in C14:C34, F5:F34, i5:i30 (blanks as above), which
cell holds the last number?


--
Best regards
Leo Heuser

Followup to newsgroup only please.