Getting Unique values only from data full of duplicates

[EXCELBENCH]

Hi,

I have multiple duplicates on column G and A.
I'd like to get the value once only from a different column and from there, I can do sumproduct to get the data using their names and date.
So the condition is that it only gets unique value Names under a specific date.
example below.
Sample Names Date.JPG

attached the file too for better reference.

Thanks in advance.

[XLent]

So, I'll assume you have good reasons for not using a Pivot Table...

One approach might be as follows

1. create a dynamic named range to restrict data volumes... wherever possible (i.e. in your sample Table is 20k rows but most are irrelevant)

Please Login or Register  to view this content.

2. Determine unique count of items such that you can then limit the number of times you analyse the table

Please Login or Register  to view this content.

3. return dates & names

Please Login or Register  to view this content.

[kvsrinivasamurthy]

ARRAY formulas are used.
In N2 then drag down

Please Login or Register  to view this content.

In O2 then drag down

Please Login or Register  to view this content.