| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List the one nonempty cell
All of column B is empty except one cell. The non-empty cell is in a
different place each week. I want a formula that will give the text in the nonempty cell, regardless of which cell is nonempty at that point in time. For example. Week 4 Cell should say "Text 4" A B 1 2 3 4 Text 4 Week 2 Cell should say "Text 2" A B 1 2 Text 2 3 4 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
| auto updating list | Excel Worksheet Functions | |||
| change size of in cell drop down list | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
Threaded Mode
