Home 
Search 
Today's Posts 
#1




How to: Find first empty cell in column
I believe there is a formula that has something about max(row, etc), but
cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don 
#2




How to: Find first empty cell in column
=MATCH(TRUE,A1:A10="",0)
entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don 
#3




How to: Find first empty cell in column
Thanks Peo, but, (and I probably didn't make myself clear, sorry),
let's say, A4 is first empty, how would I get the cell value of A3? Hope this clears it up. Again, sorry. Don "Peo Sjoblom" wrote in message ... =MATCH(TRUE,A1:A10="",0) entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don 
#4




How to: Find first empty cell in column
=INDEX(A1:A10,MATCH(TRUE,A1:A10="",1)1,0)
Don't forget to use the ctrlshift enter combination to enter this formula  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "DW" wrote: Thanks Peo, but, (and I probably didn't make myself clear, sorry), let's say, A4 is first empty, how would I get the cell value of A3? Hope this clears it up. Again, sorry. Don "Peo Sjoblom" wrote in message ... =MATCH(TRUE,A1:A10="",0) entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don 
#5




How to: Find first empty cell in column
My bad, =INDEX(A1:A10,MATCH(TRUE,A1:A10="",0)1,0)
Note that in the match formula the last parameter must be zero. Sorry about that  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Michael" wrote: =INDEX(A1:A10,MATCH(TRUE,A1:A10="",1)1,0) Don't forget to use the ctrlshift enter combination to enter this formula  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "DW" wrote: Thanks Peo, but, (and I probably didn't make myself clear, sorry), let's say, A4 is first empty, how would I get the cell value of A3? Hope this clears it up. Again, sorry. Don "Peo Sjoblom" wrote in message ... =MATCH(TRUE,A1:A10="",0) entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don 
#6




How to: Find first empty cell in column
Ctrl+Shift+Enter
=INDEX(A1:A10,MATCH(TRUE,A1:A10="",0)1,0) DW wrote: Thanks Peo, but, (and I probably didn't make myself clear, sorry), let's say, A4 is first empty, how would I get the cell value of A3? Hope this clears it up. Again, sorry. Don "Peo Sjoblom" wrote in message ... =MATCH(TRUE,A1:A10="",0) entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don 
#7




How to: Find first empty cell in column
And you don't need to use CSE to commit it.
Pete On Oct 8, 6:52 pm, Michael wrote: My bad, =INDEX(A1:A10,MATCH(TRUE,A1:A10="",0)1,0) Note that in the match formula the last parameter must be zero. Sorry about that  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Michael" wrote: =INDEX(A1:A10,MATCH(TRUE,A1:A10="",1)1,0) Don't forget to use the ctrlshift enter combination to enter this formula  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "DW" wrote: Thanks Peo, but, (and I probably didn't make myself clear, sorry), let's say, A4 is first empty, how would I get the cell value of A3? Hope this clears it up. Again, sorry. Don "Peo Sjoblom" wrote in message ... =MATCH(TRUE,A1:A10="",0) entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don Hide quoted text   Show quoted text  
#8




How to: Find first empty cell in column
You do need to enter it with ctrl + shift & enter
 Regards, Peo Sjoblom "Pete_UK" wrote in message ups.com... And you don't need to use CSE to commit it. Pete On Oct 8, 6:52 pm, Michael wrote: My bad, =INDEX(A1:A10,MATCH(TRUE,A1:A10="",0)1,0) Note that in the match formula the last parameter must be zero. Sorry about that  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Michael" wrote: =INDEX(A1:A10,MATCH(TRUE,A1:A10="",1)1,0) Don't forget to use the ctrlshift enter combination to enter this formula  If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "DW" wrote: Thanks Peo, but, (and I probably didn't make myself clear, sorry), let's say, A4 is first empty, how would I get the cell value of A3? Hope this clears it up. Again, sorry. Don "Peo Sjoblom" wrote in message ... =MATCH(TRUE,A1:A10="",0) entered with ctrl + shift & enter will find the first and return the index number so using A1:A10 and the first empty is in A4 it will return 4  Regards, Peo Sjoblom "DW" wrote in message ... I believe there is a formula that has something about max(row, etc), but cannot recall it. Col A would contain a list of numbers. I'm trying to find the first empty (blank) cell in col A. Even tho I could write a macro to do this, I'm needing the cell formula. Your help is greatly appreciated!! Don Hide quoted text   Show quoted text  
#9




How to: Find first empty cell in column
Thanks everyone....
Now, this might be a dumb question, but why the ctrl+shift + enter combo to commit the formula? Don 
#10




How to: Find first empty cell in column
It's this part
A1:A10="" it's what is called an array formula, you can lookup array formula in help http://www.cpearson.com/excel/ArrayFormulas.aspx  Regards, Peo Sjoblom "DW" wrote in message ... Thanks everyone.... Now, this might be a dumb question, but why the ctrl+shift + enter combo to commit the formula? Don 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Find empty cells, fill with text from cell above  Excel Worksheet Functions  
find first empty cell in column and start transpose next row in that cell  Excel Discussion (Misc queries)  
find last none empty cell  Excel Discussion (Misc queries)  
Find an empty cell and put a dash in it?  Excel Worksheet Functions  
Find a empty cell in next column  Excel Discussion (Misc queries) 