please help: find nonblank cell in group of cells...

[spanic]

Hello all,

Please help. How can I find nonblank cell in group of cells (one row)
and than get value from cell in that column and specified row and
return in another cell.
And repeat that in many (about 300 rows)?

Thank you

spanic


+-------------------------------------------------------------------+
|Filename: book1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5162 |
+-------------------------------------------------------------------+

 

[Harlan Grove]

spanic wrote...

Please help. How can I find nonblank cell in group of cells (one row)
and than get value from cell in that column and specified row and
return in another cell.
And repeat that in many (about 300 rows)?

Would there be just one nonblank cell in any given row? If so, and if
that row were A5:BZ5 and if you wanted the corresponding value from
A105:BZ105, you could use something like

=LOOKUP(2,1/(1-ISBLANK(A5:BZ5)),A105:BZ105)

If there could be multiple nonblank cells in any given row and you
wanted the last/rightmost one, use the formula above, but if you wanted
the first/leftmost one, use the array formula

=INDEX(A105:BZ105,MATCH(FALSE,ISBLANK(A5:BZ5),0))

 

[spanic]

Yes, it must be always only one nonblank cell in any row.
And first formula works. It solved my problem.

Thank you very much.

spanic