| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the value within specific cell position?
I would like to retrieve specific cell based on the row() and column() numbers.
For example, if cell B5 contains text "Apple", which cell's position is row()=1 and column()=2, so I would like to return the value into cell A1 based on the row and column number. Does anyone have any suggestions on how to retrieve the value within specific cell position? Thanks in advance for any suggestions |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value within specific cell position?
=b1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Eric" wrote in message ... I would like to retrieve specific cell based on the row() and column() numbers. For example, if cell B5 contains text "Apple", which cell's position is row()=1 and column()=2, so I would like to return the value into cell A1 based on the row and column number. Does anyone have any suggestions on how to retrieve the value within specific cell position? Thanks in advance for any suggestions |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value within specific cell position?
For example, if cell B5 contains text "Apple", which cell's position is
row()=5 and column()=2, so I would like to return the value into cell A1 based on the row and column number. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value within specific cell position?
Do you know any excel function will return specific cell's value based on row
and column's positions? Thanks in advance for any suggestions Eric "Don Guillett" wrote: =b1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Eric" wrote in message ... I would like to retrieve specific cell based on the row() and column() numbers. For example, if cell B5 contains text "Apple", which cell's position is row()=1 and column()=2, so I would like to return the value into cell A1 based on the row and column number. Does anyone have any suggestions on how to retrieve the value within specific cell position? Thanks in advance for any suggestions . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value within specific cell position?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Eric" wrote in message ... For example, if cell B5 contains text "Apple", which cell's position is row()=5 and column()=2, so I would like to return the value into cell A1 based on the row and column number. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value within specific cell position?
=B5
Eric wrote: For example, if cell B5 contains text "Apple", which cell's position is row()=5 and column()=2, so I would like to return the value into cell A1 based on the row and column number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to determine current cursor position? | Excel Worksheet Functions | |||
| Want to show multiple charts in one position, but determine by Lis | Charts and Charting in Excel | |||
| how do I obtain position of specific value in a row of numbers | Excel Worksheet Functions | |||
| Determine shape name associated with a specific cell | Excel Discussion (Misc queries) | |||
| Replacing a specific position in a cell with something else | Excel Discussion (Misc queries) | |||
Linear Mode
