Results 1 to 3 of 3

Need help to filter and display data based on multiple if conditions

Threaded View

tichtoe Need help to filter and... 02-08-2018, 01:56 AM
AliGW Re: Need help to filter and... 02-08-2018, 02:02 AM
leelnich Re: Need help to filter and... 02-08-2018, 02:29 AM
  1. #1
    Registered User
    Join Date
    02-08-2018
    Location
    India
    MS-Off Ver
    2007
    Posts
    1

    Need help to filter and display data based on multiple if conditions

    Hi,

    Below is the excel input.

    FROM_DATE|VALUE1|TIME_DIFFERENCE|TO_DATE|VALUE2
    2017-11-28 12:39:00|PASS|00:02:27|2017-11-28 12:41:27|101
    2017-11-28 12:39:00|PASS|00:00:02|2017-11-28 12:39:02|509
    2017-11-28 12:39:00|FAIL|05:57:01|2017-11-28 18:36:01|999
    2017-11-28 12:39:00|PASS|00:00:09|2017-11-28 12:39:09|101
    2017-11-28 12:39:02|PASS|00:05:45|2017-11-28 12:44:47|700


    In above excel TIME_DIFFERENCE is calculated as below:
    =TEXT(A1-D1,"HH:MM:SS")
    I want the output for below cases

    CASES:
    Total count of VALUE1=PASS having TIME_DIFFERENCE more than 2 minutes and having VALUE2=101
    Total count of VALUE1=PASS having TIME_DIFFERENCE less than 2 minutes and 30 sec and having VALUE2=101

    I'm trying with below formula but it does not output the data as required.
    =COUNTIFS(B1:B5,"PASS",C1:C5,"MINUTE(C1:C5)>2")

    I need help to resolve the above cases
    Last edited by AliGW; 02-08-2018 at 02:02 AM. Reason: Blue text changed back to black for legibility.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 29
    Last Post: 01-01-2017, 10:25 AM
  2. IF formula based upon multiple conditions to display text in one cell
    By jono7gold in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-07-2014, 10:29 AM
  3. [SOLVED] Drop Down Data Validation - Display a result based on multiple conditions
    By carlmf1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:50 PM
  4. [SOLVED] Vba to advance filter data on multiple conditions to many sheets with naming convention
    By 4gurus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2013, 01:01 PM
  5. Filter data based on columns, display unique row data
    By djarcadian in forum Excel General
    Replies: 14
    Last Post: 05-18-2013, 07:18 PM
  6. Get data based on multiple conditions
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2010, 10:36 AM

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