# Search:

Type: Posts; User: JenniferMurphy; Keyword(s):

Page 1 of 6 1

1. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
77

### Re: how to use a named range in the Offset function

Perfect. Thank you very much
2. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
77

### Re: how to use a named range in the Offset function

That's an interesting solution. I hadn't thought of that. It would make this formula work, but would cause all my others to fail.

Yes, but as I already said, this misses the main point. I am...
3. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
77

### Re: how to use a named range in the Offset function

Of course.

Not at all.

I assigned the name "Price" to column D and "Shares" to column E. The formulas in F6:F8 are all "=Price*Shares". That formula is able to use the values in the named...
4. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
77

### Re: how to use a named range in the Offset function

I named the range (column) because I want to use named addressing, not literal addressing. I want to use the name "Balance" in some formula that will calculate the difference between the balance in...
5. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
77

### how to use a named range in the Offset function

In the table below, I have assigned the name "Balance" to column F. I would like to replace "F6" in I6 with the named range, "Balance", but the offset function doesn't like it.

<tbody>
R/C

C...
6. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
419

### Re: Is there any way to emulate non-numeric subscripts in VBA?

The dictionary variables are working great. Thanks for that tip. Here's a section of that code.

Function TallyResults(Results As Range, Player As String, GSM As String, WL As String)

Dim rRow...
7. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
419

### Re: Is there any way to emulate non-numeric subscripts in VBA?

That fixed it. Thanks. I misunderstood that part of the tutorial.
8. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
419

### Re: Is there any way to emulate non-numeric subscripts in VBA?

I copied those examples and they get errors:

Function TallyResults(Results As Range, Player As String, WL As String, GSM As String)

Dim dict As New Scripting.Dictionary 'Error

'or
9. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
419

### Re: Is there any way to emulate non-numeric subscripts in VBA?

I think I followed the instructions exactly, but I am getting an error. Here's the code. The error is indicated in the comment on line 7. I then copied the exact code from the example and it also...
10. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
419

### Re: Is there any way to emulate non-numeric subscripts in VBA?

Marcelo,

That looks like exactly what I need. Thank you.

-j
11. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
419

### Is there any way to emulate non-numeric subscripts in VBA?

I need to tally some results for tennis players. Is there any way in Excel to emulate an array with non-numeric subscripts?

If I am reading data from a table with results for "Eliza", "Susie", and...
12. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
264

### Re: Help processing a named array in a UDF

Great. This code seems to be working.

Function TallyResults(Results As Range, Options As String)

Dim rRow As Range
Dim Winner, Loser, Set1, Set2, Set3 As String
Dim iRow As Integer
13. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
264

### Re: Help processing a named array in a UDF

That seems to work. Thanks.

I forgot one thing. The named range, "Results", actually includes a header row at the top and a summary row at the bottom that I want to skip over. Do I change the For...
14. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
264

### Re: Help processing a named array in a UDF

Great, thanks. Is rRow a variable or a keyword? If it's a variable, how do I declare it?
15. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
264

### Help processing a named array in a UDF

I would like to write a UDF that will examine the contents of each cell in a named array and return various results. The array contains the scores of tennis matches between players on a club tennis...
16. ## Thread: Still baffled by the Intersect operator

by JenniferMurphy
Replies
2
Views
154

### Re: Still baffled by the Intersect operator

Perfect. The actual expression I need is,

=INDEX(NumTrials,ROW(G6)+1)*PR_AA

But why don't any of these work?

=NumTrials (ROW(G9)+1):(ROW(G9)+1)
=NumTrials ((ROW(G9)+1):(ROW(G9)+1))
17. ## Thread: Still baffled by the Intersect operator

by JenniferMurphy
Replies
2
Views
154

### Still baffled by the Intersect operator

This table has some data from an analysis of the game of tennis. Row 4 shows the names assigned to each column. Columns D & E are assigned the names PGS_A & PGS_B, which stands for the probability of...
18. ## Thread: Accessing a cell in a named column

by JenniferMurphy
Replies
7
Views
270

### Re: Accessing a cell in a named column

Perfect. I fiddled around with the Intersect operator, but couldn't get it to work. Thanks!
19. ## Thread: Accessing a cell in a named column

by JenniferMurphy
Replies
7
Views
270

### Re: Accessing a cell in a named column

Wow!!! I'm afraid that is way over my head.

I was able to find a solution along the lines that I can comprehend. This expression eliminates literal cell references (except for the calling cell,...
20. ## Thread: Accessing a cell in a named column

by JenniferMurphy
Replies
7
Views
270

### Re: Accessing a cell in a named column

I don't understand these expressions, but I am trying to eliminate literal cell references (G6, \$G6, G\$6, or \$G\$6). I want to replace the "G7" in the expression in H6 with some form of the named...
21. ## Thread: Accessing a cell in a named column

by JenniferMurphy
Replies
7
Views
270

### Accessing a cell in a named column

In the following table, I need the formulas in columns H & I to refer to the data in column G but at one row down. Column E is assigned the name PP_A, column F the name PP_B, and column G the name...
22. ## Thread: Changing scales without exhausting Excel ;-)

by JenniferMurphy
Replies
2
Views
143

### Re: Changing scales without exhausting Excel ;-)

That's what I figured. Thanks.
23. ## Thread: Changing scales without exhausting Excel ;-)

by JenniferMurphy
Replies
2
Views
143

### Changing scales without exhausting Excel ;-)

If I have a table with average ratings of a number of products by people who were given the choice of rating them on a -5 to 5 scale. (1-5 thumbs up, 0 thumbs, 1-5 thumbs down.)

These products got...
24. ## Thread: Can a UDF access the value in a named worksheet cell?

by JenniferMurphy
Replies
18
Views
810

### Re: Can a UDF access the value in a named worksheet cell?

As a result of this warning, which I have since discovered is entirely valid, I am in the process of converting the way data is passed to the UDF, but have run into a bizarre (to me) situation that I...
25. ## Thread: In a UDF, obtain the name of a passed named range

by JenniferMurphy
Replies
17
Views
647

### Re: In a UDF, obtain the name of a passed named range

I think I did exactly what you suggest. For me, the function exits on the first execution of the For statement before any iterations.

Is this function searching all named ranges in the entire...
Results 1 to 25 of 150
Page 1 of 6 1