Thread: Using MIN & MAX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack Deuce Jack Deuce is offline
external usenet poster
 
Posts: 30
Default Using MIN & MAX

I have two columns, A being dates and B being values. How can I
display from those two columns the minimum amount and the maximum
amounts in separate cells at the bottom of the list? IOW, I'd like to
see which date (from the column A) has the maximum and minimum value.

Thanks in advance..