I'm hoping to get some advice on what functions are best to use or a subroutine to determine if a cell value is one value more (+1) or less (-1) any of the cell values in the row above it.
If true, I simply want to identify it by placing the letter "A" in a cell, else, leave blank. The "A" or blank cells would be in the same row but adjacent to the cells that the subroutine is running to determine whether it is true.
If true, I simply want to identify it by placing the letter "A" in a cell, else, leave blank. The "A" or blank cells would be in the same row but adjacent to the cells that the subroutine is running to determine whether it is true.
Below is an example of the end result I desire. Rows would be added hourly but I have a backlog of data I need to examine so I was hoping to find a solution with an autofill function or subroutine.
A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Test | G1 | G2 | G3 | G4 | G5 | A1 | A2 | A3 | A4 | A5 | |
2 | 1 | 2 | 5 | 8 | 9 | 12 | ||||||
3 | 2 | 1 | 5 | 10 | 11 | 13 | A | A | A | |||
4 | 3 | 3 | 7 | 8 | 15 | 20 | ||||||
5 | 4 | 1 | 5 | 9 | 12 | 13 | A | |||||
6 | 5 | 4 | 8 | 10 | 15 | 17 | A | A | A | |||
7 | 6 | 1 | 5 | 9 | 13 | 16 | A | A | A | |||
8 | 7 | 18 | 22 | 23 | 25 | 26 | ||||||
9 | 8 | 7 | 12 | 13 | 16 | 20 | ||||||
10 | 9 | 8 | 13 | 14 | 17 | 21 | A | A | A | A | A | |
11 | 10 | 1 | 6 | 10 | 11 | 23 | ||||||
12 | 11 | 5 | 12 | 21 | 22 | 23 | A | A | A | |||
13 | 12 | 2 | 7 | 9 | 15 | 24 | A |
<tbody>
</tbody>
Template (3)
<tbody>
</tbody>