View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Max number in a given range

Forgive me, but have you looked in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pcor" wrote in message
...
In col E I have numbers from row 1 to row 22
How do I find out the MAX(the highest) number between row 1 and 10 or row
12
and 22
Thanks