Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 09-15-2015, 02:51 PM
trainingclc trainingclc is offline Formula to return next non-blank cell in a range Windows 10 Formula to return next non-blank cell in a range Office 2013
Novice
 
Join Date: Sep 2015
Location: Houston, TX
Posts: 16
trainingclc is on a distinguished road
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to return next non-blank cell in a range 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
Formula to return next non-blank cell in a range 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
Formula to return next non-blank cell in a range How to remove blank rows from a specified range? Learner7 Excel 1 04-19-2011 02:45 AM
Formula to return next non-blank cell in a range 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft