| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need function to return text value
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need function to return text value
Assuming your data in row 1
=INDEX(1:1,MATCH(TRUE,(1:1<0),0)) ctrl+shift+enter, not just enter "sahafi" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need function to return text value
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need function to return text value
Teethless mama & Biff,
Thanks to both of you. All 3 formulas worked as I needed. -- If u change the way u look @ things, the things u look at change. "T. Valko" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TODAY function to return a date as text | Excel Discussion (Misc queries) | |||
| Need Function to look up value and return a text value? | Excel Worksheet Functions | |||
| What function do I use to return a certain value for specific text | Excel Discussion (Misc queries) | |||
| Function displays as text, doesn't return result or error | Excel Worksheet Functions | |||
| Need subtotal function to return text as result | Excel Discussion (Misc queries) | |||
Linear Mode
