Formula for change over time
Looking for a formula to access change over time at a row level moving from left to right i want to assess the percent shift from the 1st reading to the next and then assess all following reading back against the first and the previous reading to access shift overtime. If any are downward shifts greater than or equal to 20% indicate a 1 in a result column.