Hi
enter the following array formula (entered with CTRL+SHIFT+ENTER) in
CD34
=INDEX(A34:CC34,1,MIN(IF(A34:CC34="",COLUMN(A34:CC 34)))-2)

--
Regards
Frank Kabel
Frankfurt, Germany


Hello all.

I have a worksheet with 70 columns of data. I need to look back
through all columns in each row (I will need the formula in each cell
of the last row), find the first blank cell, and copy the data from
the cell in the same row but 2 columns before the blank cell.

eg. Cell T34 is blank, I want the value (text) from cell R34 copied
into cell CD 34.

I hope I've explained enough.

Thanks in advance...


---
Message posted from http://www.ExcelForum.com/