Is This Possible - without VBA?

  • Thread starter Thread starter Da~One
  • Start date Start date
D

Da~One

In cell A1 of a spreadsheet I have a number: X that can change to anything.

In row B spanning about 100 columns each cell contains either a 1 or a 0.

In row C, I want to be able to do the following:

If the column in B that matches the current column in C MINUS X number of
columns (the number in A1) is 1, do something.

EG:::
X (value in A1) = 5

Cell is C10
If B10 - 5 (which is cell B5) is 1, do something

Another EG:::
X (value in A1) = 7

Cell is C10
If B10 - 7 (which is cell B3) is 1, do something....

Is this possible at all WITHOUT using VBA?
 
the first part is easy:


C10: =IF(OFFSET(B10,-A1,0)=1,"<do something>", "")

the second part, <do something> is harder - worksheet functions can
only return values to their calling cells - they can't "do" anything
like change formatting, change the value of other cells, change
environment settings, etc. For one of those types of things, you'd
need to use VBA.
 
Back
Top