Forum Discussion
Solved
CountIFS and sequencing: Weather example
Hi, I currently have a sheet with two columns, column A is the date and column B is the weather (rain, sun, snow, cloudy) Row 1 are the headings Date, and Weather I logged the weather for...
See the attached demo workbook.
See the attached demo workbook.
What an absolute hero! Thank you so much!
The next question is:
That is for one town, if i have two cities, and want to combine output across two towns;
Town 1 town 2
Rain rain
Rain sun
Sun sun
Rain rain
Rain rain
Sun sun
Sun sun
Rain sun
So the output is
5 occurances of rain, avg 1.6days
4 occurances of sun, avg 2days
How would i do that?
Cheers
Dan
The next question is:
That is for one town, if i have two cities, and want to combine output across two towns;
Town 1 town 2
Rain rain
Rain sun
Sun sun
Rain rain
Rain rain
Sun sun
Sun sun
Rain sun
So the output is
5 occurances of rain, avg 1.6days
4 occurances of sun, avg 2days
How would i do that?
Cheers
Dan
You can simply add the days and occurrences together. See the sheet "Two Towns" in the attached workbook.
- Thank you.
If town 1 doesnt ever have Snow, but town 2 does, the UNIQUE formula wont pick up 'SNOW' from from its search of just one column. Is there a way of taking unique values from multiple columns?
Ive seen the use of FLATTEN, but my version of excel (i use the one from one drive) doesnt have FLATTEN. Is there another way?
Thanks for all your help.
Cheers
DanPerhaps it would be easier to create a fixed list of all possible weather types.
See the attached version.