| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL LOCATION!! SIMPLE QUESTION!!!!
I want to create a formula that tells me the cell location of x
ie: A 1 House The formula would tell me then: House = A1 It's this possible? thank you!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CELL LOCATION!! SIMPLE QUESTION!!!!
Try this:
With The word "house" anywhere in A1:E10 Then G1: house H1: =ADDRESS(SUMPRODUCT((A1:E10=G1)*ROW(A1:A10)),SUMPR ODUCT((A1:E10=G1)*COLUMN(A1:A10))) Does that help? *********** Regards, Ron XL2002, WinXP "HERNAN" wrote: I want to create a formula that tells me the cell location of x ie: A 1 House The formula would tell me then: House = A1 It's this possible? thank you!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CELL LOCATION!! SIMPLE QUESTION!!!!
TYPO!
The correct formula for my posted example is: H1: =ADDRESS(SUMPRODUCT((A1:E10=G1)*ROW(A1:A10)),SUMPR ODUCT((A1:E10=G1)*COLUMN(A1:E1))) (sorry about the error) *********** Regards, Ron XL2002, WinXP "HERNAN" wrote: I want to create a formula that tells me the cell location of x ie: A 1 House The formula would tell me then: House = A1 It's this possible? thank you!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CELL LOCATION!! SIMPLE QUESTION!!!!
thank you so much, it works!
"Ron Coderre" wrote: TYPO! The correct formula for my posted example is: H1: =ADDRESS(SUMPRODUCT((A1:E10=G1)*ROW(A1:A10)),SUMPR ODUCT((A1:E10=G1)*COLUMN(A1:E1))) (sorry about the error) *********** Regards, Ron XL2002, WinXP "HERNAN" wrote: I want to create a formula that tells me the cell location of x ie: A 1 House The formula would tell me then: House = A1 It's this possible? thank you!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| define one cell location throughout workbook? | Excel Worksheet Functions | |||
| Help creating a report from a data table | Excel Discussion (Misc queries) | |||
| Simple question - auto populate cells - dependent on other cell value. | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Excel cell question | Excel Discussion (Misc queries) | |||
Linear Mode
