Can't figure it out . . .
Hey Biff
Great formula. I'd been scratching my head over the OP's question.
But how does the( "z",255) make the formula work ???
Regards
Michael M
"Biff" wrote:
You missed the new users group! Still time!
=LOOKUP(REPT("z",255),A1:F1)
=INDEX(A1:F1,MATCH("*",A1:F1,0))
Biff
"
om wrote in message
...
This may be simple but, I am stumped.
I have a range of six cells in a row on my spread sheet. Five cells are
empty and one contains data. I would like to find the single cell that
contains text and copy that text into a cell at the end of the row
|