+ Reply to Thread
Results 1 to 2 of 2

FILTER with named range criteria

  1. #1
    Registered User
    Join Date
    09-08-2018
    Location
    Kamloops, Canada
    MS-Off Ver
    Office 365
    Posts
    86

    FILTER with named range criteria

    I have a named range where I want to pull employee names.

    In the example, you will see it works in cell E3 but not in cell E10 when the criteria is a named range. Is there anyway to make it work with a named range?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,105

    Re: FILTER with named range criteria

    How about
    =UNIQUE(FILTER(Employee,ISNUMBER(MATCH(Code,WestCoast,0))))

    Also as you are using 365, I would suggest updating your profile.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Possible to use a named range as criteria for date filter?
    By VBA_Newguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2017, 11:15 AM
  2. vba to filter on a named range
    By chasoe in forum Excel General
    Replies: 5
    Last Post: 06-24-2015, 06:12 AM
  3. vba to filter on a named range
    By chasoe in forum Excel General
    Replies: 0
    Last Post: 06-24-2015, 03:45 AM
  4. [SOLVED] Filter Table By Named Range
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2014, 04:13 AM
  5. [SOLVED] VBA Filter Using Named Ranges as Criteria
    By Mediterranean in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-29-2013, 04:00 PM
  6. filter data using named list criteria
    By Lizzietish11 in forum Excel General
    Replies: 3
    Last Post: 11-19-2009, 12:49 PM
  7. [SOLVED] named range with filter
    By dee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2005, 12:05 PM

Tags for this Thread

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