Thread: Maximum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Pearce Neil Pearce is offline
external usenet poster
 
Posts: 109
Default Maximum

Good morning, (or it is here!)

Using MAX() I am able to find the maximum number in a given column.

How would this be adapted to find the maximum number between a given range
of numbers, say 1000-1099, 2000-2009, if the columns conatined numbers
between 0 and 1 million?

Yours in appreciation,

Neil