Passing a row to a function

G

Guest

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()
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a function in a query 2
Logging runtime values passed to a function 2
Set non-continuous PrintArea via Function / Name 0
dynamic cell number 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Open Another File to Search and Replace Text 1
Refresh/Recalculate a Custom Function 1

Top