![]() For 'Down' column, it's just the opposite value checking. ![]() If it is a number, for 'Up' column formula, it checks the current checked cell's value if it is greater than the value above it or less than the value below and display that value if true or delete if not. I used the following table in this workaround (starting from A1), filled B2:C10 with zeroes and created a line chart with values from cell range B2:C10: Please note that I used the following formula for 'Up' column and 'Down' column, respectively: =IF(COUNT($A1)>0, IF(OR($A2$A1), $A2, 'delete'), IF($A20, IF(OR($A2>$A3, $A2$A3, $A2, 'delete')) What the formula does is check first if the value above the current checked cell is a number.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |