What is range in excel

This could be because these are new stores or there were some external factors that impacted the sales for these specific stores.

While calculating the range for this data set, it might make sense to exclude these newer stores and only consider stores where there are substantial sales. This function finds the minimum value if the criteria mentioned in it are met. In the above formula, I specified the criteria to be any value that is more than 20, So, the MINIFS function goes through the entire data set, but only considers those values that are more than 20, while calculating the minimum value.

This makes sure that values lower than 20, are ignored and the minimum value is always more than 20, hence ignoring the outliers. So, this is how you can quickly find the range in Excel using a couple of simple formulas.

Best Excel Shortcuts. Conditional Formatting. Creating a Pivot Table. Excel Tables. Usually, these two functions are not required but are useful for large tables and multiple databases and for recording macros. Knowledge of range in excel is an important pre-requisite to being able to manipulate data.

The range is also used in recording macros and VBA coding, and hence an in-depth understanding of range is a must for anyone using excel. This is a guide to Excel Function for Range. Here we have discussed Examples of Range Function in Excel along with steps and a downloadable excel template.

You may also look at the following articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Download Excel Function for Range Template.

Popular Course in this category. Course Price View Course. Free Excel Course. Login details for this Free course will be emailed to you. Email ID. This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Download Find Range Excel Template. Range in Excel By Madhuri Thakur. Popular Course in this category. Course Price View Course.

Free Excel Course. Login details for this Free course will be emailed to you. Email ID. Contact No.