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!


    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

    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    York, England
    Excel Version
    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