| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Return the Non-Blank entry
_________A
1_________ 2_________ 3_______Hello 4_________ 5_______Hello I have a single column range (A1:A4). One and only one of the cells contains a text entry (cell A3 in this example). I want to enter a formula into A5 that will return this text entry. Thanks, Art |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank cell return after each data entry | Excel Discussion (Misc queries) | |||
| Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Return blank cell if 'find' statement not true | Excel Worksheet Functions | |||
| find the first blank cell in a range and return me it's position | Links and Linking in Excel | |||
Threaded Mode
