{"id":415961,"date":"2022-03-14T18:00:41","date_gmt":"2022-03-14T15:00:41","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-find-range-in-microsoft-excel\/"},"modified":"2022-03-14T18:00:41","modified_gmt":"2022-03-14T15:00:41","slug":"how-to-find-range-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-find-range-in-microsoft-excel\/","title":{"rendered":"#How to Find Range in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a26b7bc6e5e0\" 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-6a26b7bc6e5e0\" 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-range-in-microsoft-excel\/#%E2%80%9CHow_to_Find_Range_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Find Range 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-range-in-microsoft-excel\/#Calculating_Range\" >Calculating Range<\/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-range-in-microsoft-excel\/#How_to_Calculate_Range_in_Excel\" >How to Calculate Range in Excel<\/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-range-in-microsoft-excel\/#Find_a_Conditional_Range\" >Find a Conditional Range<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Find_Range_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Find Range 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-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, 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 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-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\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re using Microsoft Excel for statistical data, you may need to find the range for a data set. Here we\u2019ll explain a simple way to calculate range in Excel using formulas.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Calculating_Range\"><\/span>Calculating Range<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Simply put, the difference between the highest and lowest numbers in a data set is known as range. If the range is high, then the data set is spread out further than if the range is low.<\/p>\n<p>As an example, this data set includes the numbers 10, 25, 50, 75, 100. To find the range, you subtract 10 (lowest number) from 100 (highest number). Here, the range is 90:<\/p>\n<pre>100 - 10 = 90<\/pre>\n<p>While this is a simple example, it\u2019s not always that easy to view your data set and <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/757264\/how-to-subtract-numbers-in-microsoft-excel\/\">do the subtraction. You may have many numbers in your data set, and they may be in varying order rather than ascending or descending. So, spotting and subtracting the highest and lowest values might not be a quick process.<\/p>\n<p>In Excel, you can use the MAX and MIN functions to find the highest and lowest values. Then, do the subtraction: MAX \u2013 MIN = Range.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Calculate_Range_in_Excel\"><\/span>How to Calculate Range in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Open your Excel sheet and select the cell where you want to display the range for your data set. For this example, we have our numbers in cells A1 through A5 and use this formula:<\/p>\n<pre>=MAX(A1:A5)-MIN(A1:A5)<\/pre>\n<p>The first part of the formula, <code>MAX(A1:A5)<\/code>, finds the highest value in the data set. The second part, <code>MIN(A1:A5)<\/code>, finds the lowest value. The minus sign in between subtracts MIN from MAX, giving us our range: 100 \u2013 10 = 90.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789292\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/RangeFormula-ExcelFindRange.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to find range in Excel\" width=\"540\" height=\"240\" 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=\"Find_a_Conditional_Range\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Find a Conditional Range<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You may have a situation where you need to find the range of your data set but want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/400211\/how-and-why-to-use-the-outliers-function-in-excel\/\">exclude certain data. For instance, maybe you have temporary figures for sales or revenue that you want to eliminate when calculating range.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How (and Why) to Use the Outliers Function in Excel<\/em><\/strong><\/p>\n<p>You can add a condition to the MAX function using MAXIFS or the MIN function using MINIFS. The syntaxes are <code>MAXIFS(max_range, criteria_range, criteria)<\/code> and <code>MINIFS(min_range, criteria_range, criteria)<\/code>. Let\u2019s look at an example.<\/p>\n<p>Here we have a data set in cells C1 through C5 where we want to calculate range but include only the high values, those above 500. We would use this formula:<\/p>\n<pre>=MAX(C1:C5)-MINIFS(C1:C5,C1:C5,\"&gt;500\")<\/pre>\n<p>The first part of the formula, <code>MAX(C1:C5)<\/code>, finds the highest value in the data set. The second part, <code>MINIFS(C1:C5,C1:C5,\"&gt;500\")<\/code>, finds the lowest value in those same cells but requires the values in those cells be higher than 500. And of course, the minus sign is our subtraction to calculate the range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789293\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/RangeConditionalFormula-ExcelFindRange.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to find conditional range in Excel\" width=\"650\" height=\"233\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>So rather than determining range with 5000 \u2013 10 = 4990, the range is calculated as 5000 \u2013 1000 = 4000, excluding those numbers below 500.<\/p>\n<p>Check out Microsoft\u2019s Support pages for these conditional functions if you\u2019re interested in other ways to use <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/maxifs-function-dfd611e6-da2c-488a-919b-9b6376b28883\">MAXIFS<\/a> or <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599\">MINIFS<\/a>.<\/p>\n<p>Finding range in your Excel spreadsheet is as easy as a formula using a couple of functions. And for those who need to take it further, you can add conditions to those formulas.<\/p>\n<p>For additional help, take a look at some basic functions you should know about 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\/789290\/how-to-find-range-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Find Range in Microsoft Excel&#8221; If you\u2019re using Microsoft Excel for statistical data, you may need to find the range for a data set. Here we\u2019ll explain a simple way to calculate range in Excel using formulas. Calculating Range Simply put, the difference between the highest and lowest numbers in a data set&#8230;<\/p>\n","protected":false},"author":1,"featured_media":415962,"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-415961","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\/415961","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=415961"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/415961\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/415962"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=415961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=415961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=415961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}