Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

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

    Perfect. Thank you very much
  2. 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. 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. 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. 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. 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. Re: Is there any way to emulate non-numeric subscripts in VBA?

    That fixed it. Thanks. I misunderstood that part of the tutorial.
  8. 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. 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. Re: Is there any way to emulate non-numeric subscripts in VBA?

    Marcelo,

    That looks like exactly what I need. Thank you.

    -j
  11. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Re: Changing scales without exhausting Excel ;-)

    That's what I figured. Thanks.
  23. 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. 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. 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 2 3 4