Incorporating the results of a MAX function in to an OFFSET Function

Originally Posted by XOR LX

Hi,

I'm a bit worried from your description that you may have entered the curly brackets {} manually (?), which is not what you should be doing (if you commit the formula correctly - with CTRL+SHIFT+ENTER - Excel will insert these automatically).

Regards

I got it working and again want to thank you for your time and expertise. What I did wrong was I copied the array formula with my cursor in the cell I want the result, then did the Ctrl+Shift+Enter and that didn't work. I erased the content, copied in to the formula bar, then did the CTRL+Shift+Enter and that works. This has encouraged me to go back and learn more about array formulas. Again.. thanks so very much for your help!