+ Reply to Thread
Results 1 to 4 of 4

Offset error

  1. 08-02-2007, 01:21 PM #1
    feejo is offline
    Forum Contributor
    Join Date
    05-18-2007
    Posts
    153

    Offset error

    When entering this I got a error on here (underline)
    =OFFSET(Sheet1!$A$7,1,0,COUNT(Sheet1!$A$6:$A$2004),1)
    Reply With QuoteRegister To Reply
  2. 08-02-2007, 02:18 PM #2
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,717
    The formula looks valid to me. If you have a non-English version of excel, though, it might expect semi-colons like ; instead of commas like ,
    Reply With QuoteRegister To Reply
  3. 08-02-2007, 03:25 PM #3
    feejo is offline
    Forum Contributor
    Join Date
    05-18-2007
    Posts
    153
    Right also I need to translate the functions names.
    Reply With QuoteRegister To Reply
  4. 08-02-2007, 03:44 PM #4
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,717
    I find this useful
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1