Need function to return text value
Another way:
=LOOKUP(REPT("z",255),1:1)
Biff
"T. Valko" wrote in message
...
Try this:
The range of interest is row 1
=INDEX(1:1,MATCH("*",1:1,0))
Biff
"sahafi" wrote in message
...
I have several columns with zero values (0), and one column that contains
text value. On another cell, I would like to have a formula/function that
searches the entire row, and return only the text value. Any help is
highly
appreciated.
Thanks.
--
when u change the way u look @ things, the things u look at change.
|