Most valuable professional
  • Hot Topics

Excel Help with Counting Unique Duplicates

Ok I will keep it simple with two rows. What I am trying to do is count unique duplicate values from one row into another row. Date 9/16/2014 9/15/2014 I am trying to count the number of repeat digits that occurred in draw 9/15 to 9/16. I am stuck with this formula and it gives me 3 which should be 2. This is my current formula and I am stuck right now. Please note I want to count the unique digits. For example the 6 and 9 was drawn on September 15 but it also came up on 9/16 too but it is counting the 9

This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of September 17, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel