| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the first cell to contain text in a column
I have a column that contains empty cells and text.
Try this: =ADDRESS(MATCH("*",A:A,0),1,4) -- Biff Microsoft Excel MVP "M" wrote: I have a column that contains empty cells and text. I want to return the reference of the first cell in the column to contain text. For example A2 = empty cell A3 = empty cell A4 = 2L The formula would return A4 Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Find a text from a column in a text string within another column? | New Users to Excel | |||
| Find cell address of last cell in a column with text | Excel Worksheet Functions | |||
| find common text in cell in column in sheet then return total amou | Excel Worksheet Functions | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
![T. Valko[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
