Results 1 to 5 of 5

Referencing a specific column within a named range

This is a discussion on Referencing a specific column within a named range within the Excel Questions forums, part of the Question Forums category; Hi, If I create a database and name it, does anyone know what the syntax is when entering a formula ...

  1. #1
    New Member
    Join Date
    Apr 2004
    Location
    Glasgow, Scotland
    Posts
    22

    Default Referencing a specific column within a named range

    Hi,

    If I create a database and name it, does anyone know what the syntax is when entering a formula for referring to a specific column within that range?

    eg. Cells A1:F50 are named Database. Row F is filled with dates. I want to find the earliest date in the database so I'll use MIN:

    =MIN(Database.....

    where do I go from here?

    Best,

    Bob

  2. #2
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,633

    Default Re: Referencing a specific column within a named range

    Hi,

    You could try:

    =MIN(INDEX(Database,,6))
    "Fair Winds and Following Seas"

  3. #3
    Board Regular WillR's Avatar
    Join Date
    Feb 2002
    Location
    Sutton Coldfield
    Posts
    1,143

    Default Re: Referencing a specific column within a named range

    or


    =DMIN(Database,I1,I1:I2)

    Where I1 contains your field name
    I2 can be blank or could specify a condition
    /**\ Regards, Will /**\

  4. #4
    New Member
    Join Date
    Apr 2004
    Location
    Glasgow, Scotland
    Posts
    22

    Default Re: Referencing a specific column within a named range

    Thanks guys but neither seems to be working and I suspect it has something to do with the fact that Database is a dynamic named range created with :

    =OFFSET(INDIRECT(ADDRESS(MATCH(17,Comments!$A$2:$A$5000,0)+1,1)),0,0,COUNTIF(Comments!$A$2:$A$5000,17),16)

    in the "Refers to" box of the "Insert Name" dialog, as prescribed by OzGrid Dave

    The methods you've suggested work fine on the same page as "Database" but I want the analysis based on another worksheet where they don't seem to be working.

    Do you know a way round it?

    Bob

  5. #5
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550

    Default Re: Referencing a specific column within a named range

    You have to include the sheet reference with Database:

    Sheet1!Database

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com