View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Find column letter of the first unused cell

On Sun, 10 May 2009 12:31:01 -0700, John
wrote:

What Excel 2007 fcn do I use to find the letter of the first column in the
row C2:C13 that is empty?

I appreciate your help, -John


Your question is unclear. You are only specifying a one column range. The
column number would be 3 if there are any empty cells in that range.

If you mean the column number of the first empty cell in a row, starting with
column C, then look below.

If you mean something else, then try rephrasing your question.


This formula must be **array-entered**:

=SUBSTITUTE(ADDRESS(1,2+MATCH(TRUE,ISBLANK(C2:XFD2 ),0),4),1,"")
^

Note that the "2" is the column number for column C less 1.
----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.
--ron