How can I count the number of repeats in a list of data?

I am trying to determine when I have repeats in a list of data. This is the
situation:

I have a list of data that contains numbers 1-99. I am trying to determine
when the numbers 1 and 2 appear in the same list and then count those
occurences. I have found a round about way of doing it, but do you know of a
faster way? Any help would be greatly appreciated. Thank you.

=Countif(A:A,1) will count number of 1s in column A

HTH

"SouthCarolina" wrote:

> I am trying to determine when I have repeats in a list of data. This is the
> situation:
>
> I have a list of data that contains numbers 1-99. I am trying to determine
> when the numbers 1 and 2 appear in the same list and then count those
> occurences. I have found a round about way of doing it, but do you know of a
> faster way? Any help would be greatly appreciated. Thank you.

Thank you for your help. I can count the number of times the number 1
appears in the column with no problem. My problems start when I try to count
the number of 1's and 2's that occur simultaneously. I will continue to work
at it.

"Toppers" wrote:

> =Countif(A:A,1) will count number of 1s in column A
>
> HTH
>
> "SouthCarolina" wrote:
>
> > I am trying to determine when I have repeats in a list of data. This is the
> > situation:
> >
> > I have a list of data that contains numbers 1-99. I am trying to determine
> > when the numbers 1 and 2 appear in the same list and then count those
> > occurences. I have found a round about way of doing it, but do you know of a
> > faster way? Any help would be greatly appreciated. Thank you.

If the 1s and 2s are independent , then is not simply:

=Countif(A:A,1)+countif(A:A,2)

OR

=if(and(countif(A:A,1)>0,countif(A:A,2)>0),"both occur","only one or none
occur")

Or have I completely missed the point (again!)

"SouthCarolina" wrote:

> Thank you for your help. I can count the number of times the number 1
> appears in the column with no problem. My problems start when I try to count
> the number of 1's and 2's that occur simultaneously. I will continue to work
> at it.
>
> "Toppers" wrote:
>
> > =Countif(A:A,1) will count number of 1s in column A
> >
> > HTH
> >
> > "SouthCarolina" wrote:
> >
> > > I am trying to determine when I have repeats in a list of data. This is the
> > > situation:
> > >
> > > I have a list of data that contains numbers 1-99. I am trying to determine
> > > when the numbers 1 and 2 appear in the same list and then count those
> > > occurences. I have found a round about way of doing it, but do you know of a
> > > faster way? Any help would be greatly appreciated. Thank you.

Sorry for not making this clear the first time, but the 1's and 2's are
dependent upon one another. I am trying to track the frequency of a set of
machines being off-line. For example, I am trying to determine when machines
1 and 2 were offline at the same time. I hope this clears up any confusion.
I am sorry that I was not clearer the first time.

"Toppers" wrote:

> If the 1s and 2s are independent , then is not simply:
>
> =Countif(A:A,1)+countif(A:A,2)
>
> OR
>
> =if(and(countif(A:A,1)>0,countif(A:A,2)>0),"both occur","only one or none
> occur")
>
> Or have I completely missed the point (again!)
>
> "SouthCarolina" wrote:
>
> > Thank you for your help. I can count the number of times the number 1
> > appears in the column with no problem. My problems start when I try to count
> > the number of 1's and 2's that occur simultaneously. I will continue to work
> > at it.
> >
> > "Toppers" wrote:
> >
> > > =Countif(A:A,1) will count number of 1s in column A
> > >
> > > HTH
> > >
> > > "SouthCarolina" wrote:
> > >
> > > > I am trying to determine when I have repeats in a list of data. This is the
> > > > situation:
> > > >
> > > > I have a list of data that contains numbers 1-99. I am trying to determine
> > > > when the numbers 1 and 2 appear in the same list and then count those
> > > > occurences. I have found a round about way of doing it, but do you know of a
> > > > faster way? Any help would be greatly appreciated. Thank you.

Then you probably need something like:

=SUMPRODUCT((A1:A100=1)*(B1:B100=2))

HTH
Kostis Vezerides