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 no blanks*

**Generic Formula **

**=COUNTA(range)**

**Formula**

**Last Column in a range: ****=COUNTA(A3:A12)**

**Last Relative Position in a Range: ****=COUNTA(A3:B12)**

**Setting up the Data**

**We will input the values as shown in FIGURE 2 in the range A3:B12**

- The result for
**last relative position in range A3:B12**and**last column in range A3:A12**will be returned in**Cell C4**and**Cell C8**respectively

* Figure 2: Setting up the Data*

**Last Relative Position in Range A3:B12**

**We will click on Cell C4**

- We will input the formula below and press the enter key

**=COUNTA(A3:A12)**

* Figure 3: Last relative position in range A3:B12*

**Last Column Position in Range A3:A12**

**We will click on Cell C8**

- We will input the formula below and press the enter key

**=COUNTA(A3:B12)**

*Figure 4: Last Column Position in Range A3:A12*

**Note:** The formulas do not work with blank cells.

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment