Glad you worked it out, Rob !

To return just the column numbers,
we could use the MATCH part of the expressions
viz, array-entered:
=MATCH(TRUE,6:6<"",0)
=MAX((6:6<"")*(COLUMN(6:6)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rob_bates" wrote in message
...
Max:

I figured it out; I put reference numbers in row 5 and then changed it
to:

=INDEX(5:5,MATCH(TRUE,6:6<"",0))

Thanks so much for your help; I learned something new!