Formula to find first empty cell in row and next empty cell in row

**Michael Wise** · 06-23-2010, 06:46 PM

Ok, not sure if this can be done in a formula but was hoping a guru could help me out with finding the first empty cell in a row of data and the next empty cell in the same row of data. Can this be done with a formula or am I looking at having to code this.
Thank you,
Michael

**davesexcel** · 06-23-2010, 07:00 PM

Check this out
http://excel.tips.net/Pages/T002103_..._a_Column.html

**Michael Wise** · 06-24-2010, 08:20 AM

Dave, thank you for the URL. After reading and trying a couple variations of this particular one =INDIRECT("B"&MAX(ROW(1:65535)*(B1:B65535<>""))) but i'm having difficulty converting it from a column view to a row view. In this instance it finds the last cell in a COLUMN with data in it. I do not have the brain power to understand how to covert this to find the First empty cell and another conversion to find the next empty cell. I'm working on it but have yet to resolve. Thank you for any further assistance. Currently trying to reverse engineer the formula referenced above.

**martindwilson** · 06-24-2010, 10:09 AM

first empty cell is =MATCH(TRUE,INDEX(C1:J1="",0),0)

**Michael Wise** · 06-24-2010, 11:13 AM

Thank you martindwilson, with the =MATCH(TRUE,INDEX(C1:J1="",0),0) I was able to use this in a series of columns in the same row adjusting where C1 progressed and using a Max at the end column to. I have attached the file to show how this was taken care of.