Making my Formula F1 Race
What I am trying to do is make Excel provide me with the next bill due.
In F1, I have:
=IF(ISERROR(MATCH("*",F4:F2000,-1)),"*",INDEX(F4:F2000,MATCH("*",F4:F2000,-1))) (provided by Stefi)
In cells A4:A2000, I manually place an "x" and the formula in F1 works.
In cells C:C, I will have the dates my bills are due, e.g.
c4 | 12/02/06
c5 | 12/10/06
c6 | 12/15/06
c7 | 12/20/06
Cells F4:f2000 checks to see if A4:A2000 is checked, e.g.
F4 =IF(A4<"",B4,"")
F5 =IF(A5<"",B5,"")
ETC.
Now, the F1 formula works perfectly if I don't have any blank cells in
A4:a(Whatever the last cell that I have an x). In other words, if I put an
"x" by the next bill due, F1 formula does what its supposed to. However, if
I remove the preceding x, then the F1 formula seems to balk.
Any suggestions on how to make the F1 formula work the way I need?
Thanks in advance.
|