Find column letter of the first unused cell
Since all the cells in C2:C13 are in Column C, I'm betting that there is no
column letter that can match your stated condition. If you meant to write
something like C2:K2, then you could use this formula to return the column
letter...
=CHAR(64+SUMPRODUCT((C2:K2="")*COLUMN(C2:K2)))
--
Rick (MVP - Excel)
"John" wrote in message
...
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
|