Anyone out there have any ideas how I can get this information? I need a
count of the number of customers who wrote bad checks that wrote them on the
same date. So of the customers with bad checks how many had more than one
check written on the same date. Please help!

"katagrga" wrote:

I am trying to find the number subtotals that have a duplicate date within
them.
I have the info subtotaled by name. The answer I need from the example
below is 4. I appreciate your suggestions.

A B
Alex Jones 1/2/08
Alex Jones 1/2/08
Alex Jones 3/4/08
4
Ben Jackson 5/1/09
Ben Jackson 5/12/09
2
Craig Meyer 7/2/08
Craig Meyer 7/2/08
2
Dan Smith 3/15/09
Dan Smith 3/24/09
Dan Smith 3/24/09
Dan Smith 5/7/09
Dan Smith 5/7/09
Dan Smith 5/7/09
6
Eric Roberts 4/6/09
Eric Roberts 4/6/09
Eric Roberts 5/17/09
3

One way to do this is to extract unique rows from your range to C1 [you need
to have headers in the first row]
(Data-Filter-Advance Filter... Copy To, Unique Values only)

Once you get the unique values in Col C&D enter this in Col E
=SUMPRODUCT(--($A$2:$A$17=C2),--($B$2:$B$17=D2))
change 17 to your last row of data.

Now you can count cells which are more than 1 in Col E to get what you want.
btw I got 5 from the sample data.
=COUNTIF(E2:E11,"1")

See http://wikisend.com/download/602840/Count Unique.xls for the file I used
to test the above.

"katagrga" wrote:

Anyone out there have any ideas how I can get this information? I need a
count of the number of customers who wrote bad checks that wrote them on the
same date. So of the customers with bad checks how many had more than one
check written on the same date. Please help!

"katagrga" wrote:

I am trying to find the number subtotals that have a duplicate date within
them.
I have the info subtotaled by name. The answer I need from the example
below is 4. I appreciate your suggestions.

A B
Alex Jones 1/2/08
Alex Jones 1/2/08
Alex Jones 3/4/08
4
Ben Jackson 5/1/09
Ben Jackson 5/12/09
2
Craig Meyer 7/2/08
Craig Meyer 7/2/08
2
Dan Smith 3/15/09
Dan Smith 3/24/09
Dan Smith 3/24/09
Dan Smith 5/7/09
Dan Smith 5/7/09
Dan Smith 5/7/09
6
Eric Roberts 4/6/09
Eric Roberts 4/6/09
Eric Roberts 5/17/09
3

Thanks so much for your response! I am almost there, but I need a bit more
help. I only want to count a name one time. From the example below, I need
to get the answer of 4. (Dan Smith has several cks written on duplicate
dates, but I only want to count as 1 not 2.) Is that possible?

"Sheeloo" wrote:

One way to do this is to extract unique rows from your range to C1 [you need
to have headers in the first row]
(Data-Filter-Advance Filter... Copy To, Unique Values only)

Once you get the unique values in Col C&D enter this in Col E
=SUMPRODUCT(--($A$2:$A$17=C2),--($B$2:$B$17=D2))
change 17 to your last row of data.

Now you can count cells which are more than 1 in Col E to get what you want.
btw I got 5 from the sample data.
=COUNTIF(E2:E11,"1")

See http://wikisend.com/download/602840/Count Unique.xls for the file I used
to test the above.

"katagrga" wrote:

Anyone out there have any ideas how I can get this information? I need a
count of the number of customers who wrote bad checks that wrote them on the
same date. So of the customers with bad checks how many had more than one
check written on the same date. Please help!

"katagrga" wrote:

I am trying to find the number subtotals that have a duplicate date within
them.
I have the info subtotaled by name. The answer I need from the example
below is 4. I appreciate your suggestions.

A B
Alex Jones 1/2/08
Alex Jones 1/2/08
Alex Jones 3/4/08
4
Ben Jackson 5/1/09
Ben Jackson 5/12/09
2
Craig Meyer 7/2/08
Craig Meyer 7/2/08
2
Dan Smith 3/15/09
Dan Smith 3/24/09
Dan Smith 3/24/09
Dan Smith 5/7/09
Dan Smith 5/7/09
Dan Smith 5/7/09
6
Eric Roberts 4/6/09
Eric Roberts 4/6/09
Eric Roberts 5/17/09
3