+ Reply to Thread
Results 1 to 2 of 2

Multiple Exclusions Function

Hybrid View

  1. #1
    Registered User
    Join Date
    07-23-2015
    Location
    USA
    MS-Off Ver
    MS10
    Posts
    5

    Multiple Exclusions Function

    Is there a another function other than the simple if statement to solve the below criteria? I need to exclude 4 and 5 so there are 4 and 5 in the JE ID Mod column, the function in a separate column needs to show "Exclude"


    JE ID Mod Exclude
    1 4
    1 5
    1
    2
    2
    2
    3
    3
    3
    4
    4
    4
    5
    5
    6
    6
    88
    99
    100

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,043

    Re: Multiple Exclusions Function

    Simpliest is to put Filter in first row and then just filter out what you want.
    Never use Merged Cells in Excel

+ 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. LARGE function with Exclusions
    By andrewc in forum Excel General
    Replies: 6
    Last Post: 03-12-2015, 06:21 AM
  2. If or Sumif with multiple criteria and a few exclusions
    By Beefy1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2014, 08:17 PM
  3. Multiple exclusions from a cubeset
    By samdthompson in forum Excel General
    Replies: 2
    Last Post: 11-21-2013, 05:54 PM
  4. LARGE Function with Exclusions
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 09-14-2011, 06:47 AM
  5. Min with exclusions
    By elfishio in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2011, 08:49 PM
  6. Count function with exclusions
    By de049 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-05-2006, 10:35 PM
  7. [SOLVED] COUNTIF formula multiple text exclusions
    By evilfeevil@gmail.com in forum Excel General
    Replies: 4
    Last Post: 06-01-2006, 04:58 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