+ Reply to Thread
Results 1 to 5 of 5

Data Name Manager Problem

  1. 05-14-2009, 11:45 PM #1
    hifliers
    hifliers is offline
    Registered User
    Join Date
    03-27-2009
    Location
    Surat,India
    MS-Off Ver
    Excel 2007
    Posts
    52

    Data Name Manager Problem

    Dear masters,

    I have Given Name for Data Column as Below

    [Data_Table=OFFSET(Data!$A$2,0,0,COUNTA(Data!$A$2:$A$28),COUNTA(Data!$1:$1))]

    Now If I delete Raw 2 System is giving Error #Ref!
    I may have to delete Raw-2 frequently

    Please how to avoid?

    Regards,

    Vishnu
    Last edited by hifliers; 05-18-2009 at 01:41 AM.
    Reply With QuoteRegister To Reply
  2. 05-15-2009, 12:08 AM #2
    mubashir aziz
    mubashir aziz is offline
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Data Name Manager Problem

    Just change A2 with A1 and put -1 to avoid heading in counting .....

    =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A$1:$A$26)-1,COUNTA(Data!$1:$1))
    Last edited by mubashir aziz; 05-15-2009 at 12:10 AM. Reason: change in formula
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
    Reply With QuoteRegister To Reply
  3. 05-15-2009, 12:48 AM #3
    hifliers
    hifliers is offline
    Registered User
    Join Date
    03-27-2009
    Location
    Surat,India
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Data Name Manager Problem

    Thanks for your early reply!

    But When I made changes It's not selecting last raw but also selecting first heading raw.

    Please suggesst where I am making mistake.

    Regards,
    Vishnu
    Reply With QuoteRegister To Reply
  4. 05-15-2009, 01:09 AM #4
    mubashir aziz
    mubashir aziz is offline
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Data Name Manager Problem

    Just take out -1 or just check may be you are entering some blank rows ......
    Reply With QuoteRegister To Reply
  5. 05-15-2009, 02:26 AM #5
    hifliers
    hifliers is offline
    Registered User
    Join Date
    03-27-2009
    Location
    Surat,India
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Data Name Manager Problem

    I have Made Below changes and it works

    =OFFSET(Data!$A$1,1,0,COUNTA(Data!$A$2:$H$37),1)

    Thanks

    Vishnu
    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