View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Max if between 2 dates?

I have dates in column A & B. They correspond to dates in column A of
sheet2... In column C (of sheet1) I would like to find the max value found on
Sheet2 in column B corresponding/between the two dates of cloumn A&B on
sheet1. Is that make sense?

Thanks for your cunning thoughts!