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.
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
Dan
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
Dan
Perhaps it would be easier to create a fixed list of all possible weather types.
See the attached version.