Support Board
Date/Time: Sat, 28 Dec 2024 07:41:14 +0000
Post From: SPREADSHEET - Tracking a Cell
| [2015-10-19 16:48:36] |
| Sawtooth - Posts: 4143 |
|
=IF(YourConditions,AA3,K4)
This formula would need to be in a K3 cell because it is repeating the previous row's value if it didn't change. =INDEX(K3:K1002,MATCH(1,P3:P1002,0),1)
This formula could be in a non-repeating cell because it will only return the most recent value. If you put in a row 3 cell, it would find the value at every '1' in column P, and repeat it until a new '1'. If used in a row 3 cell, this will essentially give you the same result at the first formula.I misled you that this formula would work if the conditions changed since K10. When used in a non-repeating cell, it will return the value at the most recent '1' in column P. The INDEX/MATCH combination is very inefficient in the New Spreadsheets, when used in a row 3 cell. However, if you use it in a non-repeating cell, the inefficiency is negligible. Without knowing exactly what you are doing, it's difficult to give exact solutions. If you want to find the second most recent value, i.e. K20, here is an example of how to return to row 3 the value at previous irregular occurrences: http://www.sawtoothtrade.com/free-stuff-5.html |