How to Loop a Formula with a Variable

[Gard5096]

I am trying to put the following formula into a loop:

=AND(Di <>"", Di >= Ei)

Where i is = iIndex

Below is what I have so far but it isn't working. Please assist.

Please Login or Register  to view this content.

Thank you,

Nick

[Richard Buttrey]

Hi,

If all you're trying to do is add a formula to column I where the number of rows varies, just use a variable to identify the last row, (you could use

Please Login or Register  to view this content.

Then rather than use a loop, (which are always slower than standard Excel functions), just add your formula to I2,

Please Login or Register  to view this content.

and then use

Please Login or Register  to view this content.

[jolivanes]

I don't know if I understood it right but is this what you have in mind?

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Sorry Richard. Had not seen your reply.

[Gard5096]

Thank you to both of you. I appreciate both tactics towards doing this, as they've provided insight for my future projects.