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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.