| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif ?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif ?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =countif ??? | Excel Discussion (Misc queries) | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Linear Mode
