superstan2310
New Member
- Joined
- Nov 3, 2024
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi All,
For the sake of not giving away the details of what I'm working on, let's say I have the below spill range. Where 1 is a cell that matches my criteria, and 0 is a cell that doesn't match my criteria.
What I am trying to do is make it so that the cells that are two rows below the "1" cells change their value from 0 to 2. For example, I have made the 0's I want changing in the below picture, red.
I need this to be dynamic as the spill range will expand over time. The closest I have gotten so far is through using SEQUENCE to give the spill cells a "row number" and saying if the row two above matches the criteria make the value equal to 2. However this leads to two issues:
1. The second row seems to think first row is two rows above, rather than one row above. I have this one sorted out.
2. The cells between the ones I want affected are ALSO being changed to 2, i.e. the values in blue.
Would anyone happen to know of a way to change the red 0's to 2's, without any other cells being affected?
For the sake of not giving away the details of what I'm working on, let's say I have the below spill range. Where 1 is a cell that matches my criteria, and 0 is a cell that doesn't match my criteria.
What I am trying to do is make it so that the cells that are two rows below the "1" cells change their value from 0 to 2. For example, I have made the 0's I want changing in the below picture, red.
I need this to be dynamic as the spill range will expand over time. The closest I have gotten so far is through using SEQUENCE to give the spill cells a "row number" and saying if the row two above matches the criteria make the value equal to 2. However this leads to two issues:
1. The second row seems to think first row is two rows above, rather than one row above. I have this one sorted out.
2. The cells between the ones I want affected are ALSO being changed to 2, i.e. the values in blue.
Would anyone happen to know of a way to change the red 0's to 2's, without any other cells being affected?