View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine the value?

Does anyone have any suggestions on how to determine the value from a list?
Under column A, there is a list of date, and under column B, there is a list
of number. I would like to determine the maximum and minimum numbers under
column B for this year 2008.
For example:
Nov-2007 31
Dec-2007 54
Jan-2008 10
Feb-2008 60
Mar-2008 50
Apr-2008 20
May-2008 35

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric