Find 1st empty cell in row?

**rjmills18** · 07-14-2008, 09:28 AM

i know this is relatively easy, i have just completely forgotten how to do it???!!!:
i need to find the first blank cell in a range of a row and return the cell value to the 1st cell of the row, or even return the column header if possible, without the use of VBA due to high security settings at my workplace!
can any one help?
thanks

**NBVC** · 07-14-2008, 09:30 AM

Can you show an example of what you've got and what you'd like as a result?

**rjmills18** · 07-14-2008, 09:37 AM

cells R:AG read:

-216.67 1083.33 -216.67 866.67 -216.67 650.00 -216.67 433.33 -216.67 216.67 -216.67 0.00 0.00

however AE is the first blank cell under a column 'October 2008', in cell J i need it to either say 'AE1' or preferrably 'October 2008'

thanks

**NBVC** · 07-14-2008, 09:48 AM

Assuming your headings are in R1:AE1

and the row of data is in R2:AE2, then try:

=INDEX($R$1:$AE$1,MATCH(TRUE,R2:AE2="",0))

confirmed with CTRL+SHIFT+ENTER not just ENTER.

**rjmills18** · 07-14-2008, 10:44 AM

i copied ur formula into the cell, it returned

#N/A

!!

**NBVC** · 07-14-2008, 10:45 AM

after you copied it and the cursor was in the formula cell... did you confirm it with CTRL+SHIFT+ENTER keys as mentioned?

**rjmills18** · 07-14-2008, 10:58 AM

sure did, without cntrl+shift it says
# VALUE
i just need a formula to tell me which cell is the 1st empty cell in the row (it will contain a formula, it will just be returning a zero, i have zero values switched off)
thanks