lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
Lets say I have a column like the one below. I want to find out which days had temperature 24 or above. or 24 and below.
So if the user enter
temp = 24
then excel will return these days
25/02/2018
04/07/2016
23/12/2016
Or excel will return all days which had 24 and below? is that possible? Thank you so much.
<colgroup><col><col></colgroup><tbody>
</tbody>
Lets say I have a column like the one below. I want to find out which days had temperature 24 or above. or 24 and below.
So if the user enter
temp = 24
then excel will return these days
25/02/2018
04/07/2016
23/12/2016
Or excel will return all days which had 24 and below? is that possible? Thank you so much.
date | temp |
11/12/2016 | 4 |
25/02/2018 | 29 |
15/10/2017 | 2 |
14/07/2017 | 19 |
18/01/2018 | 1 |
14/07/2017 | 19 |
04/07/2016 | 26 |
30/03/2016 | 16 |
28/09/2018 | 22 |
04/09/2018 | 6 |
23/12/2016 | 24 |
21/02/2016 | 2 |
<colgroup><col><col></colgroup><tbody>
</tbody>