What formula do I use - need to identify instances of 3 consecutive values over a maximum value

[Yeaman]

I have very basic excel skills but am trying to extract the number of times three consecutive cells exceed a particular value - I am trying to identify periods that temperature has exceeded a maximum value for three days or more. Also will need to include days that have not fallen below another temperature for 2 days in a row. I believe the formula I need is an IF but have no idea how to write in the logical test etc.

Any help greatly appreciated, and I would appreciate any information to be as simple as possible to follow - my excel skills only really run to adding stuff up!

Cheers

 

[FDibbins]

See if I understand you correctly. If your data loos something like below...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr]
[tr][td]

1​

[/td][td]

10​

[/td][td][/td][td][/td][/tr]

[tr][td]

2​

[/td][td]

1/1/2017​

[/td][td]

6​

[/td][td][/td][/tr]

[tr][td]

3​

[/td][td]

1/2/2017​

[/td][td]

13​

[/td][td][/td][/tr]

[tr][td]

4​

[/td][td]

1/3/2017​

[/td][td]

6​

[/td][td][/td][/tr]

[tr][td]

5​

[/td][td]

1/4/2017​

[/td][td]

10​

[/td][td][/td][/tr]

[tr][td]

6​

[/td][td]

1/5/2017​

[/td][td]

3​

[/td][td][/td][/tr]

[tr][td]

7​

[/td][td]

1/6/2017​

[/td][td]

5​

[/td][td][/td][/tr]

[tr][td]

8​

[/td][td]

1/7/2017​

[/td][td]

3​

[/td][td][/td][/tr]

[tr][td]

9​

[/td][td]

1/8/2017​

[/td][td]

13​

[/td][td][/td][/tr]

[tr][td]

10​

[/td][td]

1/9/2017​

[/td][td]

10​

[/td][td][/td][/tr]

[tr][td]

11​

[/td][td]

1/10/2017​

[/td][td]

15​

[/td][td]yes[/td][/tr]

[tr][td]

12​

[/td][td]

1/11/2017​

[/td][td]

12​

[/td][td]yes[/td][/tr]

[tr][td]

13​

[/td][td]

1/12/2017​

[/td][td]

6​

[/td][td][/td][/tr]

[tr][td]

14​

[/td][td]

1/13/2017​

[/td][td]

5​

[/td][td][/td][/tr]

[tr][td]

15​

[/td][td]

1/14/2017​

[/td][td]

8​

[/td][td][/td][/tr]

[tr][td]

16​

[/td][td]

1/15/2017​

[/td][td]

4​

[/td][td][/td][/tr]

[tr][td]

17​

[/td][td]

1/16/2017​

[/td][td]

10​

[/td][td][/td][/tr]

[tr][td]

18​

[/td][td]

1/17/2017​

[/td][td]

7​

[/td][td][/td][/tr]

[tr][td]

19​

[/td][td]

1/18/2017​

[/td][td]

2​

[/td][td][/td][/tr]

[tr][td]

20​

[/td][td]

1/19/2017​

[/td][td]

15​

[/td][td][/td][/tr]

[tr][td]

21​

[/td][td]

1/20/2017​

[/td][td]

13​

[/td][td][/td][/tr]

[tr][td]

22​

[/td][td]

1/21/2017​

[/td][td]

13​

[/td][td]yes[/td][/tr]

[tr][td]

23​

[/td][td]

1/22/2017​

[/td][td]

2​

[/td][td][/td][/tr]

[tr][td]

24​

[/td][td]

1/23/2017​

[/td][td]

9​

[/td][td][/td][/tr]

[tr][td]

25​

[/td][td]

1/24/2017​

[/td][td]

9​

[/td][td][/td][/tr]

[tr][td]

26​

[/td][td]

1/25/2017​

[/td][td]

13​

[/td][td][/td][/tr]

[tr][td]

27​

[/td][td]

1/26/2017​

[/td][td]

3​

[/td][td][/td][/tr]

[tr][td]

28​

[/td][td]

1/27/2017​

[/td][td]

14​

[/td][td][/td][/tr]

[tr][td]

29​

[/td][td]

1/28/2017​

[/td][td]

4​

[/td][td][/td][/tr]

[tr][td]

30​

[/td][td]

1/29/2017​

[/td][td]

13​

[/td][td][/td][/tr]

[tr][td]

31​

[/td][td]

1/30/2017​

[/td][td]

5​

[/td][td][/td][/tr]

[tr][td]

32​

[/td][td]

1/31/2017​

[/td][td]

6​

[/td][td][/td][/tr]
[/table]
A1 contains your max value
C4=IF(MIN(B2:B4)>=$A$1,"yes","")
copied down