Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi All,
This is possibly a popular question, but I have a problem. I have a list of data coming from an external data query. I want to use this data: 1 A 2005/09/15 11:17:40 AM 1 B 2005/09/16 11:08:09 AM 2 A 2005/09/18 12:22:18 PM 1 A 2005/09/16 12:44:56 PM 1 B 2005/09/17 12:56:22 PM 2 A 2005/09/03 01:24:10 PM 3 C 2005/09/16 03:07:15 PM 2 A 2005/09/19 11:40:56 AM And count the number of 1's, 2's and 3's there are for each date, but only if column b is equal to A or B, to end up with something like the following: 1 2 3 --------------------------------- 3/09/2005 0 1 0 15/09/2005 1 0 0 16/09/2005 3 0 0 18/09/2005 0 1 0 19/09/2005 0 1 0 I hope this makes sense. Any help would be HUGELY appreciated Regards Rob Manger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF help | Excel Worksheet Functions | |||
help please - complex countif, etc. functions | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |