Hi
What I need to get is the first date when a number appears in column M which is 9-Jan-17 (min date) and the second is the last date a number appears in column M which is 3-Feb-17 (max date) Also it must also fall between the dates that are in columns LL and LM.
Any idea how I get arrive to the answer?
Thank you
MM
<tbody>
</tbody>
What I need to get is the first date when a number appears in column M which is 9-Jan-17 (min date) and the second is the last date a number appears in column M which is 3-Feb-17 (max date) Also it must also fall between the dates that are in columns LL and LM.
Any idea how I get arrive to the answer?
Thank you
MM
Column LL | Column LM |
Date | Date |
>=40949 | <=42776 |
Column B | Column M |
Date | T2 |
10-Feb-17 | |
9-Feb-17 | |
8-Feb-17 | |
7-Feb-17 | |
6-Feb-17 | |
3-Feb-17 | 1.69 |
2-Feb-17 | |
1-Feb-17 | |
31-Jan-17 | 1.68 |
30-Jan-17 | 1.68 |
27-Jan-17 | |
26-Jan-17 | |
25-Jan-17 | |
24-Jan-17 | 1.68 |
23-Jan-17 | 1.68 |
20-Jan-17 | |
19-Jan-17 | 1.68 |
18-Jan-17 | |
17-Jan-17 | 1.67 |
16-Jan-17 | |
13-Jan-17 | |
12-Jan-17 | 1.67 |
11-Jan-17 | |
10-Jan-17 | |
9-Jan-17 | 1.67 |
6-Jan-17 | |
5-Jan-17 | |
4-Jan-17 | |
3-Jan-17 |
<tbody>
</tbody>