Formula to return next non-blank cell in a range

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to return next non-blank cell in a range

FAQ

Thread Tools

Display Modes

09-15-2015, 02:51 PM

trainingclc trainingclc is offline

Windows 10 Formula to return next non-blank cell in a range

Office 2013

Novice

Join Date: Sep 2015

Location: Houston, TX

Posts: 16

I think I coppied the wrong cell. That was the formula I had in row 16 and for some reason FALSE has a space in it. I guess you figured that out.

=IFNA(IF(ISBLANK(A12),"",INDEX(A13:A110,MATCH(FALS E,ISBLANK(A13:A110),0))),"")

I also took out the $ since that would only allow for 100 rows max.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If id cell range is empty then should not allow to fill any other cell	ubns	Excel Programming	2	04-12-2015 06:31 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
How to remove blank rows from a specified range?	Learner7	Excel	1	04-19-2011 02:45 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:13 PM.