Finding the nth Blank Value in a Row of Text

		Microsoft Office Forums > Microsoft Excel > Excel
Finding the nth Blank Value in a Row of Text

FAQ

Thread Tools

Display Modes

01-09-2016, 05:48 AM

xor

Windows 10 Finding the nth Blank Value in a Row of Text

Office 2013

Expert

Join Date: Oct 2015

Posts: 1,101

Name A1:J1 as d and use the matrix formula:

=IFERROR(INDEX(d,SMALL(IF(d<>"",COLUMN(d)-CELL("col",d)+1),COLUMNS($E:E))),"")

for listing the first non-blank text. Copy the formula to the right to list second, third etc. non-blank text.

If you do not want to use IFERROR, you can instead use:

=IF(COLUMNS($E:E)>SUM(--(d<>"")),"",INDEX(d,SMALL(IF(d<>"",COLUMN(d)-CELL("col",d)+1),COLUMNS($E:E))))

Tags

formula help

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
finding a string containing a combination of formats and adding text before	Marco	Word VBA	1	11-02-2015 05:08 PM
Finding and Replacing a word with text copied to clip board	spc94	Word VBA	3	06-25-2015 04:46 AM
Finding varying text in an MS Word file	sergiodcq	Word	1	07-08-2014 03:12 AM
Finding specific text within body of email	Tammfran	Outlook	0	03-14-2014 02:32 PM
Finding a text style in a cell	jimbassett	Excel	1	02-10-2010 08:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 AM.