Mady
Reputation: 1
How do I calculate number of days with at least 6 consecutive days when the temperature >90th percentile in excel?
I have daily temperature data of a place. I need to calculate the temperature indices. need help in calculating the number of days with at least 6 consecutive days when the temperature is >90th percentile. help me with composing the formula in excel. thanks in advance!
Upvotes: -1
Views: 52
Answers (1)
user22566114
Reputation: 391
Certainly too late for an answer however this works in Excel for the web and Office 365.
=SUM(N(SCAN(0,A1:Z1,LAMBDA(ini,arr,IF(arr>90,ini+1,0)))=6))
Upvotes: 0
Related Questions
- How can I calculate the number of lost weather days in Excel?
- Excel Consecutive Days with at least 60 minutes worked
- count the number of 3 consecutive days or more in R
- Counting consecutive days of temperature data
- Excel formula - Get the sum of each variable every 6 days
- Calculate Number of Consecutive Days Where a Condition Applies Across Two Columns
- Count number of days in a row with weather above certain temp with pandas
- Calculating the amount of overlapping days between two ranges
- How to count the number of instances where the wind directions is < (-3.54) for >= 5 consecutive days in a season
- Counting number of unique days that a certain value falls in using Excel FOrmula