Some thoughts ..

Return First column (leftmost):
Put in say, A5, then array-enter (Press CTRL+SHIFT+ENTER):
=INDEX(6:6,MATCH(TRUE,6:6<"",0))

Return Last column (rightmost)
Put in say, B5, then array-enter (Press CTRL+SHIFT+ENTER):
=INDEX(6:6,,MAX((6:6<"")*(COLUMN(6:6))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rob_bates" wrote:
Is there a formula that returns the first (or last) column that is populated
in a row?

Row 6 has A6=blank, B6=1, C6=5, D6=4, E6=blank

If looking for the first number, I would like it to return Column B, for the
last, Column D.

Thanks!

Rob.