Results 1 to 2 of 2

Thread: OFFSET Formula Error

  1. #1

    OFFSET Formula Error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have the attached spreadsheet where I want to use the OFFSET formula to do a dynamic chart that will give the 20 latest updated scores. When I delete both columns (A2 where I have the datees and B2 where I have the scores), I end up having an error message stating : A formula in this worksheet contains one or more invalid references.

    I have checked the offset formula from the Name Manager and I don't see the error. Can someone please help?

    FYI the scores go from 0 to 1 the highest

    Thanks
    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Hello
    You appear to have the error in your VBA code even without deleting columns, but your code is password protected , so I cant look at it.

Posting Permissions

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