 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Max number in a given range
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 Forgive me, but have you looked in the help index for MAX  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > 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 Thanks > Forgive me, but have you looked in the help index for MAX > [quoted text clipped - 3 lines] > > and 22 > > Thanks > MAX(the highest) number between row 1 and 10 In say, F1: =MAX(E1:E10) If you mean comparing just 2 cells, E1 and E10. then in F1: =MAX(E1,E10) SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > 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 Thanks you very much > > MAX(the highest) number between row 1 and 10 > In say, F1: =MAX(E1:E10) [quoted text clipped - 5 lines] > > and 22 > > Thanks welcome SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > > Thanks you very much Hi Not sure what you mean. Do you want the max number between E1and E10 =MAX(E1:E10) or MAX(E12:E22) or the maximum of E1:E22 but excluding E11 =MAX(MAX(E1:E10),MAX(E12:E22)) SignatureRegards Roger Govier > 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 You were the most helpful by far Most sincere thanks...and BTW it worked very well Thanksagain > Hi > [quoted text clipped - 9 lines] > > and 22 > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.