catalincirjan
New Member
- Joined
- Aug 28, 2020
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
Hello,
I am trying to identify the cells in an array that haven't been modified in the past 2 weeks and have a list of those cell references.
Array in question: F3:T500
Sheets:
1.cells in present time "Tracks"
2. cells as they were 2 weeks ago "Past" // the assumption is that this sheet is automatically updated with the version of Tracks of two weeks ago
Precondition: C cell value for that row equal "In Progress"
What I was thinking of is a formula per row that will look like =IF(C3="In Progress",here use formula with array F3:T3 ,"")
Now regarding the formula inside this if, I have been trying to use the CELL/ADDRESS formula in combination with IF(Tracks!F3:T3=Past!F3:T3), but I can't get anywhere ...
All of this also goes on my assuption that the formula will Spill for the entire row and then I can modify the formula for each row that will also Spill eventually?!
Any advice is highly appreciated!
Hope I was able to explain what it is I want to do here ....
I am trying to identify the cells in an array that haven't been modified in the past 2 weeks and have a list of those cell references.
Array in question: F3:T500
Sheets:
1.cells in present time "Tracks"
2. cells as they were 2 weeks ago "Past" // the assumption is that this sheet is automatically updated with the version of Tracks of two weeks ago
Precondition: C cell value for that row equal "In Progress"
What I was thinking of is a formula per row that will look like =IF(C3="In Progress",here use formula with array F3:T3 ,"")
Now regarding the formula inside this if, I have been trying to use the CELL/ADDRESS formula in combination with IF(Tracks!F3:T3=Past!F3:T3), but I can't get anywhere ...
All of this also goes on my assuption that the formula will Spill for the entire row and then I can modify the formula for each row that will also Spill eventually?!
Any advice is highly appreciated!
Hope I was able to explain what it is I want to do here ....