Howdy folks,

I was using the MAX function to find the highest value for a certain set of numbers in Column F. My function is =MAX(F320:F465)

How do I:
A - Display the cell's # so that it is easy to locate the MAX figure returned by the function within the sheet?
B - Display a cell's value that is in Column A, but in the same row as the MAX function result?
(Column A is the date for the value returned in the MAX function in column F)

Thank you for your time folks,
M