Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display cell name
Hi,
Say in cell B4 contains text "John". Based on text "John", I'd like to display "B4" (colomn and row of cell that contains "John") in other cell. How is the formula to do that? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display cell name
What is the range to be searched for text "John"? If it is restricted to
column B, then =ADDRESS(MATCH("John",$B:$B,0),2,4,1) returns B4. If the search area contains more than one column, you have to create a UDF, as far as I know. Regards, Stefi js ezt *rta: Hi, Say in cell B4 contains text "John". Based on text "John", I'd like to display "B4" (colomn and row of cell that contains "John") in other cell. How is the formula to do that? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display cell name
Stefi,
Thanks a lot. it's help me. rgds js "Stefi" wrote: What is the range to be searched for text "John"? If it is restricted to column B, then =ADDRESS(MATCH("John",$B:$B,0),2,4,1) returns B4. If the search area contains more than one column, you have to create a UDF, as far as I know. Regards, Stefi js ezt *rta: Hi, Say in cell B4 contains text "John". Based on text "John", I'd like to display "B4" (colomn and row of cell that contains "John") in other cell. How is the formula to do that? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display cell name
You are welcome! Thanks for the feedback!
Stefi js ezt *rta: Stefi, Thanks a lot. it's help me. rgds js "Stefi" wrote: What is the range to be searched for text "John"? If it is restricted to column B, then =ADDRESS(MATCH("John",$B:$B,0),2,4,1) returns B4. If the search area contains more than one column, you have to create a UDF, as far as I know. Regards, Stefi js ezt *rta: Hi, Say in cell B4 contains text "John". Based on text "John", I'd like to display "B4" (colomn and row of cell that contains "John") in other cell. How is the formula to do that? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
have one cell display text which reflects a number in another cell | Excel Discussion (Misc queries) | |||
Display contents of cell in another cell as part of text string? | New Users to Excel | |||
How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
large text amount in cell will not display in the cell | Excel Discussion (Misc queries) |