Numbers formula request to show date of a max value

I have a spread sheet with $ values (price of gas) in one column with the date in a separate column. I can pull the max value in that column but how can I pull the date it occurred?

Thank you for your time, and possible solution.

iPad, iPadOS 26

Posted on Oct 20, 2025 1:02 PM

Reply
Question marked as Top-ranking reply

Posted on Oct 20, 2025 2:44 PM

Hi Ralph,


Try this.



Formula in Footer cell B8 is XLOOKUP(MAX(C),C,B)


Regards,

Ian.

2 replies

Numbers formula request to show date of a max value

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.