Count Unique Values by category

  • Hey Guys


    Can you please help me count unique values by Category. But the catch is if the product is already there in Batch1 it should not be counted in the Batch2. It should count only the unique values in Batch 2 which are not part of Batch 1 and 3. Same with Batch3.. the products must not repeat in Batch 1 or 2.


    Please find the sample sheet attached and also the desired output which I got using the pivot table.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!