Even more Complex COUNTIF functionality

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
rob.manger@xxxxxxxxx

.

Relevant Pages

  • Using Parameters in an external data query
    ... For some reason, whenever I do an external data query, the Parameters ... button/feture is ghosted and unavailable. ... Prev by Date: ...
    (microsoft.public.excel)
  • Help : Using Parameters with External Date Query
    ... For some reason, whenever I do an external data query, the Parameters ... button/feture is ghosted and unavailable. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • System Status?
    ... This has to be a popular question, but a search in google did not give me an ... Mahalo! ... Prev by Date: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: set intersection -> true/false
    ... > This question has already been answered on this newsgroup within the last ... It must be a popular question with programming instructors. ... Prev by Date: ...
    (comp.programming)