View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ronnomad ronnomad is offline
external usenet poster
 
Posts: 47
Default Min/Max with IF(?) criteria

I have two columns. A contains numbers, B contains text days of week (Mon,
Tue, etc.) starting from 01/01/07. How do I write a formula that will give
me the Min in column A based on the day of the week, discounting any days
where the the number in A is zero (presumably the same formula will work for
Max).

Thanks,

Ron R.