Everything is explained in the excel file but here is a sneak peak of it:
I have most of the formulas down i just need to put them all together...
HTML Code:
Component Type/Operation Status/Order Status/ID #
64 in queue active DU1H3333
64 in queue active DU1H3334
64 in queue active DU1H3333
60 in queue stop DU1H3336
60 active stop DU1H3337
60 hold stop DU1H3338
60 active stop DU1H3337
64 in queue active DU1H3340
64 in queue active DU1H3340
64 active active DU1H3342
I am trying to count the # of components with component type "64", operation status "in queue" or "active", order status "active" and the ID #'s cannot be the same
The answer for this example is 4
I have thousands of components that the function will search through.