Forum Discussion
Solved
How to create trends without empty cells.
I measure temperatures irregularly during the month and year. I don't know how to create the trend that doesn't include dates with blank values. Thank you.
Pepa
If you have Microsoft 365 or Office 2021, you can use the FILTER function to extract only the dates with non-blank values (and the corresponding values of course). Use the result of the FILTER formula for your trend calculations.
2 Replies
If you have Microsoft 365 or Office 2021, you can use the FILTER function to extract only the dates with non-blank values (and the corresponding values of course). Use the result of the FILTER formula for your trend calculations.
HansVogelaar That's what i needed. Thank you for your advice.
