I have a list of values (Column A). Against each value, I want to know the last 5 values that are below zero from that row onwards.
For example:
I want queries in Columns C to G that I can drag down. As the query drags down, I want the values to appear.
If this helps, the values in column A go as far as about row 12000.
I am therefore guessing that I will end up with separate queries in columns C to G…
An example sheet is showing below
<tbody>
</tbody>
For example:
I want queries in Columns C to G that I can drag down. As the query drags down, I want the values to appear.
If this helps, the values in column A go as far as about row 12000.
I am therefore guessing that I will end up with separate queries in columns C to G…
An example sheet is showing below
A | B | C | D | E | F | G | |
1 | |||||||
2 | 1ST | 2ND | 3RD | 4TH | 5TH | ||
3 | -89.8 | -89.8 | -89.6 | -35.2 | -7.4 | -15.5 | |
4 | 22.4 | -89.6 | -35.2 | -7.4 | -15.5 | -13.8 | |
5 | 52.3 | -89.6 | -35.2 | -7.4 | -15.5 | -13.8 | |
6 | 1 | -89.6 | -35.2 | -7.4 | -15.5 | -13.8 | |
7 | -89.6 | ||||||
8 | -35.2 | ||||||
9 | -7.4 | ||||||
10 | -15.5 | ||||||
11 | 27.3 |
<tbody>
</tbody>