=LOOKUP(w23-w22,{-999,0,0,999},{"D","R","U"})
Excel Workbook | ||||
---|---|---|---|---|
W | X | |||
23 | 1 | D | ||
24 | 9 | U | ||
25 | 8 | U | ||
26 | 1 | U | ||
27 | 1 | U | ||
DIGIT REPEATS |
Cell Formulas | ||
---|---|---|
Range | Formula | |
X23 | =LOOKUP(W23-W24,{-999,0,0,999},{"D","R","U"}) | |
X24 | =LOOKUP(W24-W25,{-999,0,0,999},{"D","R","U"}) | |
X25 | =LOOKUP(W25-W26,{-999,0,0,999},{"D","R","U"}) | |
X26 | =LOOKUP(W26-W27,{-999,0,0,999},{"D","R","U"}) | |
X27 | =LOOKUP(W27-W28,{-999,0,0,999},{"D","R","U"}) |
Mr Poulsom, the values are running from bottom to top.
if the value in W23 is smaller than W22, return a "D"
Excel Workbook | |||||
---|---|---|---|---|---|
M | N | O | |||
5 | 09/08/14 | 6 | U | ||
6 | 09/07/14 | 3 | D | ||
7 | 09/06/14 | 9 | R | ||
8 | 09/05/14 | 9 | |||
SKIPSUMS |