display text in a cell in a range of cells

S

Shu of AZ

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.
 
R

Rick Rothstein

Not sure if this is the most efficient formula or not, but it works...

=INDEX(R1:R59,SUMPRODUCT((R1:R59<>"")*ROW(R1:R59)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display text from a single cell in a column range 2
Excel Typed text appears in wrong cell 0
Finding Text within an Array 2
Combining Text From Cells 3
Split Cell Range into Multiple Cells 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel 2003 - Maximum number of characters a cell can contain? 1
Stepping down a cell when a value is entered 2

Top