Edit: Split from [Solved] Conditional IF query |
It is a very long (and I mean very long) time ago that I wrote a couple of programs where a line had an index variable (say I) and the statement began something like Step (I=1 to 25) followed by a function containing I and some conditional statements.
I'm sure this can be implemented as a macro but I was hoping that a single cell function might be available that does something similar.
What I'm trying to to is to take some action in the current row that is based on data contained in rows ahead of the current row but behind the current column, where the target row is an unknown amount ahead but the range is limited. Hope that makes sense. It is a project I've been meaning to do for quite a while but have only just decided to sort it out. I now have 8 years of data that needs correcting in order to be useful!
Peter