View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default how do I return tthe location (cell) when using the max function

Consider using:

=HLOOKUP()
--
Gary''s Student
gsnu200709


"Holke" wrote:

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?