Forum Discussion
X+1 +1 +1... till match a condition
Hi,
I have this table that needs to do a formula on:
J3 of J2+x till B3>=H3.
J4 of J3+x till B4>=H4.
J5 of J4+x till B5>=H5.
...
Is this possible without macros?
Hello,
what is "J3 of J2"? Can you manually mock up a few examples of what you want to achieve in a spreadsheet and post that workbook? Then explain the logic.
Sry for my bad english :S
Hope now u can understand with this examples
H3 has a formula that refers to J3. You can't now put a formula into J3 that refers to H3. That is a circular reference.
Step back from the table and explain what you need to achieve. What is the bigger picture?