Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
Can this be done using an array formula ? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
MAKING A FORMULA FOR CHANGING AMOUNTS | Excel Discussion (Misc queries) |