| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Passing a row to a function
I need to take the row value of the cell in which a function appears and pass
that value into the function itself. As in the example below, cells A1, A2, A3 all contain the function getName(), I would like getName() to evaluate differently based on the row number. Is this possible? COLUMN ROW A B 1 =getName() 2 =getName() 3 =getName() |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Passing a row to a function
row()?
"dch3" wrote: I need to take the row value of the cell in which a function appears and pass that value into the function itself. As in the example below, cells A1, A2, A3 all contain the function getName(), I would like getName() to evaluate differently based on the row number. Is this possible? COLUMN ROW A B 1 =getName() 2 =getName() 3 =getName() |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Passing a row to a function
That will work. In the future, you may want to elaborate a little bit more. I
didn't understand your response until I opened Excel and tried the function. I obviously wasn't aware that it was a valid Excel function. "Barb Reinhardt" wrote: row()? "dch3" wrote: I need to take the row value of the cell in which a function appears and pass that value into the function itself. As in the example below, cells A1, A2, A3 all contain the function getName(), I would like getName() to evaluate differently based on the row number. Is this possible? COLUMN ROW A B 1 =getName() 2 =getName() 3 =getName() |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
