Results 1 to 8 of 8

Finding values based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    CAMBRIDGE
    MS-Off Ver
    Excel 2007
    Posts
    4

    Finding values based on multiple conditions

    Hi Guys,
    I need help with formulas to create data for audits. My data relates to vehicle pass and fail rates at annual inspection. The government stats only take into account the first time a vehicle is presented for inspection first time and not when its retested. I've managed to find a formula to calculate the number of tests from my list using this formula
    =ArrayFormula(SUM(IF(FREQUENCY(IF(LEN(B2:B200)>0,MATCH(B2:B200,B2:B200,0),""),IF(LEN(B2:B200)>0,MATCH(B2:B200,B2:B200,0),""))>0,1)))

    My problem is that i now have to count the pass and fail rate but only on the data that is found in the formula above. I hope this makes sense.

    Thanks guys!
    Attached Images Attached Images
    Last edited by T21PAC; 01-30-2014 at 08:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  2. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  3. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  4. Help modifying macro to wrap iferror formulas around existing formulas
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:04 PM
  5. Replies: 5
    Last Post: 05-05-2008, 02:22 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