Results 1 to 3 of 3

Thread: row reference

  1. #1
    Join Date
    Feb 2007
    Location
    The Farm
    Posts
    35

    Unanswered: row reference

    How can I reference a row that is N rows above the current row? I see in the documentation that there is R[]C[] notation, but if I turn that feature on it converts all my references and some of them need to be absolute. Hope this is making sense.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    When you turn on R1C1 reference style, any cells that are already set to absolute $B$4 will convert to R4C2. Cells that are not absolute B4
    will convert to R[-1]C[-2] The lack of [] makes it an absolute reference.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Feb 2007
    Location
    The Farm
    Posts
    35
    Thanks. I didn't get that when I looked at them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •