so… i have hourly readings recorded for a 1 year duration. i managed to get the mean monthly values (in a separate worksheet) for each month using a formula that selects the values of Jan, Feb, etc. Hence, the mean monthly is always set from Jan-Dec.
…but, I want that if I start inputting the data from Feb, for instance, (instead of Jan), the mean monthly shall display the results in the same month order, in this example also starting from Feb. why? because if i start data from Dec 2023 and end Nov 2024, the mean monthly shall start at Dec 23 (and not from Jan as it would be in 2024). hope I’m clear, sorry if not!
i used formulas that select the Jan data (month 1) Feb (month 2)…and so on… and obtain the mean value of each month. But the order remains Jan-Dec.
David Bugeja is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.