All resources related to RANGE for Excel and Google Sheets.

Last row number in range

While working with Excel, we are able to determine the last row number of any data set by using the ROW and ROWS functions. There are also other formulas that use either the MIN or INDEX function in combination with ROW and ROWS. This step by step tutorial will assist...

How to Get the Last Row in Mixed Data with No Blanks

We can determine the last relative position WITHIN A RANGE for mixed data that has no empty cells with the COUNTA function. The COUNTA function counts the number of values in a range. The steps below will walk through the simple process. Figure 1: Last row in mixed data with...

First Match Between Two Ranges

Excel allows us to find the first match between two ranges with INDEX, MATCH and COUNTIF functions. This step by step tutorial will assist all levels of Excel users to learn how to get the first matchable value from the two arrays. Figure 1. Get the first match between two...

Range contains numbers

Excel allows a user to check if a range contains numbers, by using the SUMPRODUCT and ISNUMBER functions. As a result, we get a TRUE, if a range contains numbers or FALSE. This step by step tutorial will assist all levels of Excel users in checking if a range contains...

Last row in mixed data with blanks

Excel allows us to get the last row in mixed data with blanks using the MATCH function. This step by step tutorial will assist all levels of Excel users in getting the last row in mixed data with blanks. Figure 1. The result of the MATCH function Syntax of the...

How to Check If Range Contains a Value Not in Another Range in Excel

We often compare one range values with another range to check for duplicates. But how to check if one range values exist in another range in Excel? We will learn in this article how to check if a range contains a value not in another range in Excel. Figure 1....

How to Count Total Cells in a Range

We can count the total number of cells, rows, and column in a range by using the COLUMNS function and the ROWS function. The steps below will walk through the process. Figure 1: Total number of Cells in the Range Formula to Count Total Cells in a Range =ROWS(range)*COLUMNS(range) Setting...

How to Get Relative Column Numbers in a Range

We can get a complete set of relative column numbers in a range with an array formula that is based on the COLUMN function. The steps below will walk through the process. Figure 1: Result of Relative Column Numbers in a Range: General Formula {=COLUMN(range)-COLUMN(firstcell)+1} Formula =COLUMN(A3:E3)-COLUMN(A3)+1 Setting up the...

All values in a range are at least

We can check if all values in a range are greater than or equal to a certain number by independently using or combining the COUNTIF, IF and NOT functions. This tutorial will step through the process. Figure 1: All values in a range are at least Setting up the Data...

How to Check If All Values in a Range Are at Least a Certain Criteria

Want to learn how to check if values in a range are above a certain threshold? This post will give you an overview of how to do so using the COUNTIF function in Excel. How to Check If All Values in a Range Are at Least a Certain Criteria in...