Results 1 to 5 of 5

Named range that returns range in column A based on criteria looking at column B

Threaded View

nxf Named range that returns... 07-17-2013, 11:13 AM
oeldere Re: Named range that returns... 07-17-2013, 11:23 AM
nxf Re: Named range that returns... 07-17-2013, 12:14 PM
oeldere Re: Named range that returns... 07-17-2013, 12:26 PM
nxf Re: Named range that returns... 07-19-2013, 04:35 AM
  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    St Asaph
    MS-Off Ver
    Excel 2007
    Posts
    4

    Named range that returns range in column A based on criteria looking at column B

    Not quite sure how the best way to word what I want but here goes,

    What I have existing is:

    In column A
    I have a list of names (i.e. 1307081624GILHSSHIRE, which are always made up of date, time, project & name with the date & time as yymmddhhmm). From time to time a new name gets added to the top, forcing all entries down one row).

    In column B
    I have a list of dates (date formatted) that are "concatenated" from the names in column A (i.e. 08-07-2013).

    My objective is to have a named range that looks at column A but only at a portion that is set by a portion of the dates in column B which are between a start date in C1 and an end date in D1. So when I change C1 and/or D1 the named range result will change.

    There may be a solution that just looks only at column A as I only added column B as I thought it is best that the searchable column is date formatted?

    Any help would be brilliant.
    Thanks.
    Attached Files Attached Files
    Last edited by nxf; 07-17-2013 at 12:13 PM. Reason: added file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Named Range Based on Column Header
    By kcguyton in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2013, 12:14 PM
  2. [SOLVED] CountIF for dynamic length column using criteria of Named Range
    By saber0091 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2013, 02:04 PM
  3. Fill down cells in column based on named range
    By Pademba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2013, 02:34 PM
  4. [SOLVED] Dynamic Named Range Help - Range Based on Values in Column
    By Filibuster in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-03-2012, 11:13 AM
  5. Select cells based on named Range and a column heading
    By achidsey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2005, 11:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1