Results 1 to 21 of 21

Multiple fields and want only 1 answer = TRUE or = FALSE

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    MT
    MS-Off Ver
    Excel 2014
    Posts
    18

    Multiple fields and want only 1 answer = TRUE or = FALSE

    I have created a much larger report, but I am trying to filer the data for something I believe should be very simple. It is proving very difficult and I'm not sure how to get the data out I desire. Below I have listed a sample section from the document.

    I am trying to calculate if the data ever shows FALSE then the "PO Correct?" is false. As you see in 300415 the PO is TRUE, therefor the PO was correct. For 300697 the PO was correct 2 times (TRUE) so the PO is correct. On 301220, the PO is TRUE (4) times, but (1) FALSE, therefor the PO was not correct.

    PO # PO Correct?
    300415 TRUE

    300697 TRUE
    300697 TRUE

    301220 TRUE
    301220 FALSE
    301220 TRUE
    301220 TRUE
    301220 TRUE

    In this report I dumped data from QuickBooks and am trying to mine if a PO was ever changed in the system, then the PO was not correct from the time it was issued to the time it was received.

    Any help anyone could offer on this would be greatly appreciated. I have spent a few hours working on how to figure this out and I am assuming it is a simple solution. I'm not sure if I need to use a formula, macro, pivot chart, exc...
    Last edited by edanielqsf; 04-22-2014 at 11:09 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] another simple formula
    By oceanside in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-22-2013, 04:57 AM
  2. Replies: 4
    Last Post: 12-07-2012, 11:49 AM
  3. Formula for Discount Percentage
    By Ali H in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-18-2012, 04:05 AM
  4. simple formula
    By Shooter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2005, 04:06 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