View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Holke Holke is offline
external usenet poster
 
Posts: 2
Default how do I return tthe location (cell) when using the max function

I keep weekly values of my investments in a row and then search with the max
function. How can I return the date (row 3 of the colum that max value is
in) that the max value occured?