Pivot Table / Unique Values

[Carl]

Hello.

I have a table with 2 Columns and 300000 Rows.

ColA ColB
May 5 BOX12
May 5 BOX10
Jun 2 BOX05
Jun 2 BOX05
Jun 3 BOX112

Can a Pivot Table Return the following ?

Date Count Unique Products
May 5 2
Jun 2 1
Jun 3 1

Thank you advance

 

[Daniel.M]

Hi Carl,

Have your data sorted by ColA and ColB

Use an helper ColC with a title of "SpotUnik"

In C2 the following formula:
=0+OR(A2<>A3,B2<>B3)

Copy to Cx

Make your PV Table (by ColA) and sum on ColC

Regards,

Daniel M.