Record Max Temp Each Day

You didn't enter it as an array. They're a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer.

That is an incorrect statement. They need to fix it (and I have suggested they do it a few times)!

It is possible to get a correct result depending on the circumstances.

I didn't know that - do you happen to have a reference to an example?

There was a post a couple of weeks ago that demonstrated this perfectly.

I'll see if I can find it but it will be later this evening as I have to go offline for several hours.

See this:

https://www.excelforum.com/showthread.php?t=1085118