Okay, to count how many people are multiple-bad-check-per-day-writers, no
matter how many times they did it, try this:

Re-arrange your pivot table fields this way:

Column Labels = B
Row Labels = A
Values = Count of B

Your pivot table should now show all the names alphebetically in the first
column, then a column for each individual date. The dated columns will show
the total number of bad checks written by each person on that date (if any).

NEXT: In the first blank cell after the first person's row in your pivot
table, write the following formula:


=MAX(rowstart:rowend)

Replace "rowstart:rowend" with the cell reference for the first dated column
through the last dated column in that person's row. (Don't include the Grand
total column!!) This formula should return the largest daily "bad check"
total for that person. Copy the formula down so each row now has a "max"
value.

At the bottom of the table, enter this formula as a subtotal to the MAX
formulas:

COUNTIF(columnstart:columnend,"1")

Replace "columnstart:columnend" with the cell reference for the first row
through the last row. (Don't include the Grand total row!!) This formula
will count how many people had a maximum per-day-bad-check-count greater than
1.