"flub" wrote:
Thanks for that. When using the Offset function how
do I reference the current cell that the formula is in.

That's what I was going for originally. But I cannot remember,
if there is even a way. I hope someone will answer your
question.

In your example you use C3 etc but what if I want to
place a formula in any cell. How do I reference the
"current" cell.

I realized that you can simply refer to the current cell by
name. When you copy the formula, the relative reference
will be updated to reflect the new cell location. Won't that
work for you?

And that is when I realized, klunk!, that for the same reason,
there is really no need to use OFFSET() at all in this context
-- at least to the extent that I understand it (not much!).

If you start with "IF(C3 = C2, ...)" in C3, when you copy
that to C4, for example, it will be changed to "IF(C4 = C3, ...)".
If you copy it to Z7, it will be changed to "IF(Z7 = Z6, ...)".

But honestly, I am not sure if any of this meets your needs.
To be honest, I did not completely follow your requirements.
I suspect you want if-then-else contructs, not a sequence
of if-statements. But as I said before, I am not paying close
enough attention to your application to really comment.
I should not have "butted in", and I wouldn't have were it
not for the fact that you seem to be at a dead-end with the
other ideas. ("Killing an ant with a sledgehammer" comes
to mind. But again, perhaps I am simply not familiar enough
with your requirements.)

I am not thinking clearly. I just finished 3(!) hours of intense
exercise.