## How to find the nth non blank cell in Excel?

How could you find and return the nth non blank cell value from a column or a row in Excel? This article, I will talk about some useful formulas for you to solve this task.

**Find and return the nth non blank cell value from a column with formula**

**Find and return the nth non blank cell value from a row with formula**

#### ** Find and return the nth non blank cell value from a column with formula**

For example, I have a column of data as following screenshot shown, now, I will get the third non blank cell value from this list.

Please enter this formula: **=INDEX($A$1:$A$25,SMALL(ROW($A$1:$A$25)+(100*($A$1:$A$25="")), 3))&""** into a blank cell where you want to output the result, D2, for example, and then press **Ctrl + Shift + Enter** keys together to get the correct result, see screenshot:

**Note**: In above formula, * A1:A25* is the data list that you want to use, and the number

*indicates the third non blank cell value which you want to return, if you want to get the second non blank cell, you just need to change the number 3 to 2 as you need.*

**3**#### ** Find and return the nth non blank cell value from a row with formula**

If you want to find and return the nth non blank cell value in a row, the following formula may help you, please do as this:

Enter this formula:** =INDEX($A$1:$M$1,SMALL(IF($A$1:$M$1<>"",COLUMN($A$1:$M$1)-COLUMN($A$1)+1),4))** into a blank cell where you want to locate the result, and then press **Ctrl + Shift + Enter** keys together to get the result, see screenshot:

**Note:** In above formula, * A1:M1* is the row values that you want to use, and the number

*is the fourth non blank cell value which you want to return, if you want to get the second non blank cell, you just need to change the number 4 to 2 as you need.*

**4**### Best Office Productivity Tools

**Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. ** **Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...**

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!