lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I would like to find out those days that either NY temperature of 29 or higher or LA had a temperature 26 or higher. I would like to know the date that it occurred and what the Price and Nextday-prices were. Any help would be very much appreciated. Thank you.
Sample of the data
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
.
.
.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
The file can be downloaded here
https://drive.google.com/file/d/1G6K4jiLwNjLx4bllMxgmudJyGFCjPxTa/view?usp=sharing
I would like to find out those days that either NY temperature of 29 or higher or LA had a temperature 26 or higher. I would like to know the date that it occurred and what the Price and Nextday-prices were. Any help would be very much appreciated. Thank you.
Sample of the data
Date | NY temperature | LA temperature | Price | Nextday price |
02/07/2018 | 32.22 | 26.91 | 49.92 | 69.88 |
03/07/2018 | 32.85 | 28.51 | 48.81 | 54.3 |
05/07/2018 | 30.69 | 24.58 | 53.43 | 43.77 |
06/07/2018 | 28.92 | 23.16 | 30.02 | 35.19 |
09/07/2018 | 27.74 | 25.52 | 40.59 | 34.6 |
10/07/2018 | 32.22 | 26.98 | 44.87 | 42.53 |
11/07/2018 | 31.08 | 24.13 | 42.01 | 38.76 |
12/07/2018 | 28.51 | 23.96 | 34.69 | 36.94 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
.
.
.
24/09/2018 | 19.06 | 17.15 | 23.27 | 31.95 |
25/09/2018 | 24.55 | 20.03 | 31.98 | 37.05 |
26/09/2018 | 26.22 | 19.17 | 35.34 | 37.4 |
27/09/2018 | 17.01 | 14.34 | 27.04 | 32.37 |
28/09/2018 | 20.56 | 16.63 | 30.24 | 30.97 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
The file can be downloaded here
https://drive.google.com/file/d/1G6K4jiLwNjLx4bllMxgmudJyGFCjPxTa/view?usp=sharing