+ Reply to Thread
Results 1 to 3 of 3

Filter Formula with and or

  1. #1
    Registered User
    Join Date
    02-08-2021
    Location
    Michigan, USA
    MS-Off Ver
    O365
    Posts
    48

    Filter Formula with and or

    Hello I have a file I am trying to use filter function for in order to create a list of users who are assigned to a specific location and need to take a certain class. What I keep getting is anyone assigned the system no matter the location they are at. I have attached a file for example with the filter I have tried to use and the outcome I am looking for. One thing to keep in mind, this formula will be inside a bigger formula already capturing users who are assigned a class and providing a list based on that class where location does not matter. Please let me know if there are any questions or if further explanation is needed. Thank you for your help.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Filter Formula with and or

    Initial proposal:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by DJunqueira; 11-06-2021 at 03:38 AM. Reason: Improve formula

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

    Re: Filter Formula with and or

    You need an extra set of brackets around the or section of the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Replies: 2
    Last Post: 10-24-2021, 08:03 AM
  2. Replies: 0
    Last Post: 05-05-2021, 12:36 AM
  3. Replies: 1
    Last Post: 01-08-2015, 07:02 PM
  4. [SOLVED] I need formula or macro to filter a number of items from different tables at single filter
    By Karthikeyannb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2014, 11:04 AM
  5. Need to filter a report filter based on the previous filter
    By elliotencore in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2014, 07:44 AM
  6. Replies: 1
    Last Post: 06-20-2008, 02:47 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