Successive cells over a particular value

[tigerzen]

Looking for a formula/function that will calculate how many times sales of 100 were achieved over 2 successive dates, in the sample data the first instance is the 22 and 23 Feb. Further to that, is there a formula that will return the dates that it was achieved.
Other formula that would be handy is the largest streak, in other words what was the greatest number of successive dates in which 100 was achieved. This would be 19th March to 22nd March with 4.

Book10
	A	B
1	Sales	Date
2	127	19-Feb-22
3	104	20-Feb-22
4	97	21-Feb-22
5	115	22-Feb-22
6	73	23-Feb-22
7	98	24-Feb-22
8	144	25-Feb-22
9	134	26-Feb-22
10	126	27-Feb-22
11	78	28-Feb-22
12	87	1-Mar-22
13	66	2-Mar-22
14	115	3-Mar-22
15	117	4-Mar-22
16	91	6-Mar-22
17	121	7-Mar-22
18	53	8-Mar-22
19	68	9-Mar-22
20	145	11-Mar-22
21	80	12-Mar-22
22	64	13-Mar-22
23	126	14-Mar-22
24	66	15-Mar-22
25	78	16-Mar-22
26	77	17-Mar-22
27	65	18-Mar-22
28	129	19-Mar-22
29	130	20-Mar-22
30	101	21-Mar-22
31	100	22-Mar-22
32	66	23-Mar-22
33	78	24-Mar-22
34	119	25-Mar-22
35	141	26-Mar-22
36	81	27-Mar-22
37	58	28-Mar-22
38	55	29-Mar-22
Sheet1

 

[James006]

Hi,
Not sure to understand ...
Isn't your first instance on 19-Feb-2022 and 20-Feb-2022 ... ???

 

[tigerzen]

Hi,
Not sure to understand ...
Isn't your first instance on 19-Feb-2022 and 20-Feb-2022 ... ???

Hi James,

You are correct, I've uploaded another file. In the uploaded file it is 19th and 20th Feb.

 

[James006]

Hi,
You can test following formula

=MAX(FREQUENCY(IF(A2:A38>=2,ROW(A2:A38)),IF(A2:A38>=100,ROW(A2:A38))))

 

[tigerzen]

Hi,
You can test following formula

=MAX(FREQUENCY(IF(A2:A38>=2,ROW(A2:A38)),IF(A2:A38>=100,ROW(A2:A38))))

Thanks James, your formula works nicely.

Any ideas on how to return the date those successive values were achieved and also what the longest streak was?