{"id":768,"date":"2011-07-20T10:20:52","date_gmt":"2011-07-20T10:20:52","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=19"},"modified":"2023-12-31T00:02:35","modified_gmt":"2023-12-31T00:02:35","slug":"excel-training-calculating-highest-lowest-numbers","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-training-calculating-highest-lowest-numbers\/","title":{"rendered":"Excel Training: Finding the Highest and Lowest Numbers"},"content":{"rendered":"<p>If you have a lot of data in Excel and you want to find the highest or lowest number in a row, column or range of cells, Excel provides an easy way to produce this answer for you, without the need to sort your data.<\/p>\n<p><strong>Lowest number:<\/strong><\/p>\n<p>The Excel function to find the lowest number in a range is <strong>=MIN()<\/strong><\/p>\n<p>For example, say you have a lot of numbers in cells C5 to C15. If you want to find the lowest number in that range, and show the answer in cell C4, you would:<\/p>\n<ul>\n<li>Click on cell C4<\/li>\n<li>Type: =MIN(<\/li>\n<li>Use the mouse to select and drag from cell C5 to C15, let go of mouse button<\/li>\n<li>Type: )<\/li>\n<li>Press Enter.<\/li>\n<\/ul>\n<figure id=\"attachment_20\" aria-describedby=\"caption-attachment-20\" style=\"width: 419px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-lowest.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-lowest.jpg\" alt=\"Finding the lowest number in Excel using Min function\" width=\"419\" height=\"529\" \/><\/a><figcaption id=\"caption-attachment-20\" class=\"wp-caption-text\">Finding the lowest number in Excel using Min function<\/figcaption><\/figure>\n<p>Note: if you want to include another set of data, simply separate each range with a comma. eg. \u201cC5:C15,E5:E15\u2033<\/p>\n<p><strong>Highest number:<\/strong><\/p>\n<p>Similarly, if you want to find the highest number, say from a new range of numbers, D5 to D15, you would use the <strong>=MAX()<\/strong> function.<\/p>\n<p>So, if you want to show the answer in cell D4, you would follow these steps:<\/p>\n<ul>\n<li>Click on cell D4<\/li>\n<li>Type: =MAX(<\/li>\n<li>Use the mouse to select and drag from cell D5 to D15, let go of mouse button<\/li>\n<li>Type: )<\/li>\n<li>Press Enter.<\/li>\n<\/ul>\n<figure id=\"attachment_21\" aria-describedby=\"caption-attachment-21\" style=\"width: 420px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-highest.jpg\"><img decoding=\"async\" class=\"size-full wp-image-21\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-highest.jpg\" alt=\"Showing the highest number in Excel using the Max function\" width=\"420\" height=\"512\" \/><\/a><figcaption id=\"caption-attachment-21\" class=\"wp-caption-text\">Finding the highest number in Excel using the Max function<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>If you have a lot of data in Excel and you want to find the highest or lowest number in a row, column or range of cells, Excel provides an easy way to produce this answer for you, without the need to sort your data. Lowest number: The Excel function to find the lowest number [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[80,81,220,222,226,230,254,273,274,280,281,471,500,501],"class_list":["post-768","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-calculate-excel-lowest-number","tag-calculate-highest-number","tag-excel-training-y","tag-excel-training-highest-number","tag-excel-training-lowest-number","tag-excel-training-calculating-highest-and-lowest-number","tag-finding-highest-and-lowest-numbers","tag-get-highest-number","tag-get-lowest-number","tag-high-or-low-value","tag-highest-or-lowest-value","tag-rt","tag-sort-data-from-highest-to-lowest","tag-sort-data-from-lowest-to-highest"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=768"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/768\/revisions"}],"predecessor-version":[{"id":6803,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/768\/revisions\/6803"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}