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
|