PDA

View Full Version : Extracting Unique Values in Column that meets criteria



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?

snb
09-06-2016, 07:55 AM
I was thinking about pivottables...