View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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