6 Replies Latest reply: Dec 1, 2015 9:29 PM by Jonathan Poole RSS

    Inverse Selection or Where Not Exists??? Please Help

      Good Morning Everyone

       

      Simple as it sounds, I am very confused over this and don't really know what I am doing. Please consider the following table:

       

      ItemCode          EventCode

      001                    Start

      001                    Finish

      002                    Start

      002                    Finish

      003                    Finish

      004                    Start

       

      I want to know the number of Item codes that have a finished Event code which have also got a start event code as well, in this case the number would be 2, but I need the formula...help!!

       

      Kind Regards,

       

      Miles