Compare columns were data exists in both locations and filter results

[Gamefanatic]

Hope someone can help me wrap my brain around this.

We have a large database of work orders where we need to generate a report that will be used by management to quickly identify areas of concern. The data is exported from our ticketing system and analyzed using Excel. In order to make things easier for management to use the data I wanted to come up with a sheet that would take any exported data and present the results they were looking for.

They want to see a list of WO# that are found on the DATA tab, where techs exist on Report!A:A, and finally reduce the results by only showing the WO# with certain status values identified in the named range "Status_Open".

I was able to get a list of WO# to be identified using the array criteria below, but still need to ensure that we list only list work orders where the Tech's showing on the Report tab.

Please Login or Register  to view this content.

-TIA!

[avk]

Simply using Pivot table you can monitoring open status.
Refer attach file "Pivot" Sheet.