Extracting Unique Values in Column that meets criteria
In a table, I need to extract the unique values in Column H only if the values in Column A matches the criteria in cell K2. In other words, if cell K2 is dated 8/31/2016, then only the unique values in column H that has a due date of 8/31/2016 (column A) is extracted.
Then once the unique value of Column H is extracted, I also need the unique values in Column C (Details), along with its count and totals.
For example, one unique item in column H is AA083116WNY that has a due date of 8/31/2016. It contains 3 unique values in column C, these are
I need to present them in SEPARATE FILES (for each uniques in Column H that corresponds to criteria 8/31/2016 in column A) in the following:
Please find the details for: