Consecutive 5 Maximum number in a column

[ssb648]

In a data of numbers , I want to find in which are the 5 consecutive days the maximum production has occurred.
For example , on day 1-5 production was 20,21,22,23,24 and on day 6-10 it was 25 ,19,20,23,25 so my answer is from day 2 to 6 are the consecutive days where production was maximum.
How to present this in a sheet. Please help.
Thanks .

[karedog]

Maybe :

Please Login or Register  to view this content.

[ssb648]

Yes we Did this and found the maximum number in a column. But how to lacate the cell number and then answer should be like Date -- to -- are the highest production days .
Thanks for your help.

[karedog]

You are welcome.

Please Login or Register  to view this content.