Share via

Name Manager - Copy and paste formula error

Anonymous
2018-10-02T05:11:00+00:00

When copy and pasting: =OFFSET(Lists!$K$6,1,,COUNTA(Lists!$K$7:$K$300)) into the Name Manager it responds with an error "We found a problem with this formula.

All other copy and pasting worked? What an i missing please?

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-10-03T11:54:55+00:00

Good day OssieMac

TY for all the trouble. There were 2 issues. One the formulas used to generate the date was in USA format which was different to my machine default settings. The syntax for formulas differs. They used a , and mine was set to ;.

Thank you got it sorted.

Was this answer helpful?

0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-10-02T10:44:20+00:00

    Hi OssieMac

    Yes it does have data in the range in the first top 30 spots. Rest is blank for now.

    Have deleted it all and manually retyped and no change.

    Regards

    Was this answer helpful?

    0 comments
  2. OssieMac 48,001 Reputation points Volunteer Moderator
    2018-10-02T08:55:09+00:00

    Do you actually have data in the range Lists!$K$7:$K$300 because I think that a zero count will not work.

    Also try deleting the named range and re-create it.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-10-02T07:09:24+00:00

    OssieMac

    Thanks but still have an issue?

    Was this answer helpful?

    0 comments
  4. OssieMac 48,001 Reputation points Volunteer Moderator
    2018-10-02T06:10:35+00:00

    You have missed the last parameter (argument) to tell it 1 column wide.

    =OFFSET(Lists!$K$6,1,,COUNTA(Lists!$K$7:$K$300),1)

    Was this answer helpful?

    0 comments