{"id":514218,"date":"2022-11-22T21:00:35","date_gmt":"2022-11-22T18:00:35","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/"},"modified":"2022-11-22T21:00:35","modified_gmt":"2022-11-22T18:00:35","slug":"how-to-find-the-smallest-or-largest-number-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/","title":{"rendered":"#How to Find the Smallest or Largest Number in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6aedfd9d9f221\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6aedfd9d9f221\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/#%E2%80%9CHow_to_Find_the_Smallest_or_Largest_Number_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Find the Smallest or Largest Number in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/#Use_the_SMALL_Function\" >Use the SMALL Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/#Use_the_LARGE_Function\" >Use the LARGE Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/#A_Limitation_to_Note\" >A Limitation to Note<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Find_the_Smallest_or_Largest_Number_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Find the Smallest or Largest Number in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Use the SMALL function to find the smallest number and the LARGE function to find the largest number. Use either Excel function in the form =SMALL(range,position) or =LARGE(range,position). For example, =SMALL(B2:E13,1) will find the first smallest number in the range of cells between B2 and E13.<\/p>\n<p>When you have a spreadsheet packed with data, finding\u00a0the number you need\u00a0can be tedious. Yet, whether you\u2019re looking for the lowest product sales amount or the highest test score, Excel\u2019s SMALL and LARGE functions can help.<\/p>\n<p>Using these two Excel functions, you aren\u2019t limited to only finding the smallest or largest number in a cell range. You can also locate the second smallest, third smallest, or fifth largest. For a quick way to find the number you want, here\u2019s how to use the SMALL and LARGE functions in Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_SMALL_Function\"><\/span>Use the SMALL Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The syntax for the function is <code>SMALL(range, position)<\/code> where both arguments are required. You\u2019ll enter the range or array for the <code>range<\/code> argument. For the <code>position<\/code> argument, enter a one for the first smallest number, two for the second smallest number, three for the third, and so on.<\/p>\n<p>As an example, we\u2019ll locate the smallest number in our cell range B2 through E13 using this formula:<\/p>\n<pre>=SMALL(B2:E13,1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837700\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/Smallest-ExcelSMALLLARGE.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SMALL function for the first smallest number\" width=\"650\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As another example, we\u2019ll find the second smallest number in that same cell range. Here\u2019s the formula:<\/p>\n<pre>=SMALL(B2:E13,2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837699\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/SecondSmallest-ExcelSMALLLARGE.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SMALL function for the second smallest number\" width=\"650\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_LARGE_Function\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Use the LARGE Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The LARGE function works the same way as the SMALL function, only providing you with the biggest number. The syntax is <code>LARGE(range, position)<\/code> with both arguments required and representing the same data as the SMALL function.<\/p>\n<p>To find the largest number in our cell range B2 through E13, we\u2019ll use this formula:<\/p>\n<pre>=LARGE(B2:E13,1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837702\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/Largest-ExcelSMALLLARGE.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"LARGE function for the first largest number\" width=\"650\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To locate the third largest number in that same cell range, we can use this formula:<\/p>\n<pre>=LARGE(B2:E13,3)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837701\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/ThirdLargest-ExcelSMALLLARGE.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"LARGE function for the third largest number\" width=\"650\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"A_Limitation_to_Note\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">A Limitation to Note<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It\u2019s important to note a specific limitation when you use these functions. If you have <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/816924\/excel-highlight-duplicates\/\">duplicate numbers in your data, your result is skewed when finding different positions. Here\u2019s an example.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Highlight Duplicates in Microsoft Excel<\/em><\/strong><\/p>\n<p>Below, we searched for the largest number in our cell range B2 through E13. The result is 1,800, which is correct.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837704\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FirstLargest-ExcelSMALLLARGE.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"LARGE function for the first largest number\" width=\"650\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>But, if we look for the second largest number in that same cell range, our result is also 1,800. This is because 1,800 appears twice, making it both the largest and second largest number.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837703\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/DuplicateLargest-ExcelSMALLLARGE.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"LARGE function for the first largest number resulting in a duplicate\" width=\"650\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Consider this limitation when searching for various positions in your cell range.<\/p>\n<p>If you want to quickly find the lowest five sales totals in your product sheet or the highest three monthly bills in your budget, keep the SMALL and LARGE functions in mind.<\/p>\n<p>For more, learn how to use INDEX and MATCH to find specific values or how to find range in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/837694\/how-to-find-the-smallest-or-largest-number-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Find the Smallest or Largest Number in Microsoft Excel&#8221; Use the SMALL function to find the smallest number and the LARGE function to find the largest number. Use either Excel function in the form =SMALL(range,position) or =LARGE(range,position). For example, =SMALL(B2:E13,1) will find the first smallest number in the range of cells between B2&#8230;<\/p>\n","protected":false},"author":1,"featured_media":514219,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-514218","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/514218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=514218"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/514218\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/514219"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=514218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=514218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=514218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}