Results 1 to 4 of 4

How to selectively filter the searches based on a criteria (Index function)

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    79

    How to selectively filter the searches based on a criteria (Index function)

    Hiya!

    On cells H11:K33, a list of data gets showed and filtered when any of the Active X buttons (Acct 1, 2 and 3 where the person is designated) are selected which shows the Employee Name, Hire Date, Tenure Age and Status. How can the formula in these cells adjusted to only show those people with statuses of OVERDUE, RED FLAG, NEARING, ONGOING and FALSE. Basically, if the employee has a status of REGULAR, do not include his/her data on the list that gets filtered?

    Thank you so much respectively!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter and extract list of data based on criteria using INDEX MATCH
    By brake in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-13-2018, 08:30 AM
  2. [SOLVED] INDEX Function to return a value based on multiple criteria.
    By carterbu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2013, 03:02 PM
  3. [SOLVED] 2 or more Index Match Searches in one?
    By nobodyukno in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 01:48 PM
  4. [SOLVED] Selectively Import Rows into Excel from a CSV file based on criteria
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-18-2012, 01:14 PM
  5. Index/Match Formulas - Search/Filter Based on Specific Criteria
    By Christopher.Belanger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2012, 08:42 AM
  6. Replies: 6
    Last Post: 10-23-2011, 03:14 PM
  7. [SOLVED] Macro function needed for varied searches using a data filter
    By CC_rider in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2005, 03: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