Hi,
Im trying to find the address of the First Five Row numbers in a given column where continuously the cell values are >= X. There can be multiple instance where we can find continuous rows where cell values are >=X, but I need the first occurrence only.
For example in column A, continuously values in the 5 rows i.e., A5 A6 A7 A8 A9 are >=x(10) and also in row number A13 A14 A15 A16 A17 etc. But the row# A5 to A9 is the first occurrence (first five consecutive values) and I need the address of the row numbers as output i.e., A5:A9
Row# Column A
<colgroup><col><col></colgroup><tbody>
</tbody>
Im trying to find the address of the First Five Row numbers in a given column where continuously the cell values are >= X. There can be multiple instance where we can find continuous rows where cell values are >=X, but I need the first occurrence only.
For example in column A, continuously values in the 5 rows i.e., A5 A6 A7 A8 A9 are >=x(10) and also in row number A13 A14 A15 A16 A17 etc. But the row# A5 to A9 is the first occurrence (first five consecutive values) and I need the address of the row numbers as output i.e., A5:A9
Row# Column A
1 | 2 |
2 | 12 |
3 | 14 |
4 | 8 |
5 | 10 |
6 | 10 |
7 | 10 |
8 | 10 |
9 | 10 |
10 | 2 |
11 | 2 |
12 | 5 |
13 | 10 |
14 | 10 |
15 | 10 |
16 | 10 |
17 | 10 |
18 | 10 |
19 | 5 |
20 | 3 |
<colgroup><col><col></colgroup><tbody>
</tbody>