| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display text in a cell in a range of cells
I have a column of cells r1:r59. Each day all but one will be blank and will
contain text. That may be cell r6. The next day all but one will be blank and will contain text but different. It may be cell r51. This changes daily and the cell that may have the text in is not predetermined. I need a formula that will display the text in the cell that is filled that day and display it in another area of the sheet. B4. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display text in a cell in a range of cells
Not sure if this is the most efficient formula or not, but it works...
=INDEX(R1:R59,SUMPRODUCT((R1:R59<"")*ROW(R1:R59)) ) -- Rick (MVP - Excel) "Shu of AZ" wrote in message ... I have a column of cells r1:r59. Each day all but one will be blank and will contain text. That may be cell r6. The next day all but one will be blank and will contain text but different. It may be cell r51. This changes daily and the cell that may have the text in is not predetermined. I need a formula that will display the text in the cell that is filled that day and display it in another area of the sheet. B4. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display text from a single cell in a column range | Excel Discussion (Misc queries) | |||
| Check if a cell contains text compared to a range of cells | Excel Discussion (Misc queries) | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| How can I display a cell range in a text box in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
