swaggerbox
09-06-2016, 05:49 AM
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
***_AA_BLUE_20160806_011437
***_AA_BROWN_20160806_011437
***_AA_BLACK_20160806_011437
The total count for these is 3
The sum is:
***_AA_BLUE_20160806_011437 = 1
***_AA_BROWN_20160806_011437 = 2
***_AA_BLACK_20160806_011437 = 3
Therefore 1+2+3 = 6
17032
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:
AA083116WNY
***_AA_BLUE_20160806_011437 1
***_AA_BROWN_20160806_011437 2
***_AA_BLACK_20160806_011437 3
TOTAL 6
COUNT 3
I have attached sample source WB, and desired output files.
Can anyone help?
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
***_AA_BLUE_20160806_011437
***_AA_BROWN_20160806_011437
***_AA_BLACK_20160806_011437
The total count for these is 3
The sum is:
***_AA_BLUE_20160806_011437 = 1
***_AA_BROWN_20160806_011437 = 2
***_AA_BLACK_20160806_011437 = 3
Therefore 1+2+3 = 6
17032
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:
AA083116WNY
***_AA_BLUE_20160806_011437 1
***_AA_BROWN_20160806_011437 2
***_AA_BLACK_20160806_011437 3
TOTAL 6
COUNT 3
I have attached sample source WB, and desired output files.
Can anyone help?