| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find column letter | Excel Discussion (Misc queries) | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| How do I find a cell starting with a specific letter? | Excel Discussion (Misc queries) | |||
| Find column letter containing specific data | Excel Worksheet Functions | |||
Threaded Mode
