Then maybe you should.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Michelle" wrote in message
...
No

"James M" wrote:

Michelle,

Have you tried using a pivot table?

J

"Michelle" wrote:

I have a spread sheet and I need to count the # of times something
happens
per day. Example would be I have the following data.
Date Outcome
1.1.05 Y
1.2.05 Y
1.2.05 Y
1.2.05 N
1.2.05 N
1.3.05 N
1.3.05 Y

I want the results to be as follows
Date Positive Negative
1.1.05 1 0
1.2.05 2 2
1.3.05 1 1 etc.