+ Reply to Thread
Results 1 to 4 of 4

Advanced Filter error

  1. #1
    Registered User
    Join Date
    11-21-2020
    Location
    Flora, IL
    MS-Off Ver
    365
    Posts
    2

    Advanced Filter error

    I work in a manufacturing company. I am trying to create an automated manning roster of each of the 3 shifts with a reports tab of each shift and then a report of all shifts combined (by automated I mean whatever is updated or changed in the roster will update the charts as well). We are wanting to be able to visually see only the "Inactive" (OPEN, FMLA and OUT) by Supervisor, by position, by how many are each by supervisor ect. I have spent many hours and can not get it. I tried the advanced filter function but I keep getting an error: extract range has a missing or invalid field name. Unless someone has a different idea of how to get only the columns to the chart sheet to create the charts I am stumped.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,808

    Re: Advanced Filter error

    I'm not sure exactly what you're looking for, but delete everything you have in cells A2:c8 on the Charts tab and then put this in cell A2
    =FILTER(FILTER('Manning Roster 1st shift'!$A$4:$H$10,('Manning Roster 1st shift'!$H$4:$H$10="OUT")+('Manning Roster 1st shift'!$H$4:$H$10="FMLA")+('Manning Roster 1st shift'!$H$4:$H$10="OPEN")),{1,1,0,0,0,0,0,1})

    Is this on the right track?

  3. #3
    Registered User
    Join Date
    11-21-2020
    Location
    Flora, IL
    MS-Off Ver
    365
    Posts
    2

    Re: Advanced Filter error

    I tried to plug in that formula and I got an error. I do not know what I am doing wrong. But I am really wanting this to work. Can I send you my actual file?

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,808

    Re: Advanced Filter error

    It's attached. The formula is in cell A2
    Attached Files Attached Files

+ 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. [SOLVED] Advanced filter error message
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-29-2015, 06:50 AM
  2. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  3. Advanced Filter Error
    By csh8428 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 05:56 PM
  4. [SOLVED] Advanced Filter Error
    By Floyd Bates in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 02:20 PM
  5. Advanced Filter - error message
    By Mifty in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-25-2006, 02:10 PM
  6. Advanced Filter Error
    By Claret in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2006, 11:55 AM
  7. advanced filter error 1004
    By Tove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2005, 04:06 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