software

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

quot;SouthCarolinaquot; wrote:

gt; I am trying to determine when I have repeats in a list of data. This is the
gt; situation:
gt;
gt; I have a list of data that contains numbers 1-99. I am trying to determine
gt; when the numbers 1 and 2 appear in the same list and then count those
gt; occurences. I have found a round about way of doing it, but do you know of a
gt; 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.

quot;Toppersquot; wrote:

gt; =Countif(A:A,1) will count number of 1s in column A
gt;
gt; HTH
gt;
gt; quot;SouthCarolinaquot; wrote:
gt;
gt; gt; I am trying to determine when I have repeats in a list of data. This is the
gt; gt; situation:
gt; gt;
gt; gt; I have a list of data that contains numbers 1-99. I am trying to determine
gt; gt; when the numbers 1 and 2 appear in the same list and then count those
gt; gt; occurences. I have found a round about way of doing it, but do you know of a
gt; gt; 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)gt;0,countif(A:A,2)gt;0),quot;both occurquot;,quot;only one or none
occurquot;)

Or have I completely missed the point (again!)

quot;SouthCarolinaquot; wrote:

gt; Thank you for your help. I can count the number of times the number 1
gt; appears in the column with no problem. My problems start when I try to count
gt; the number of 1's and 2's that occur simultaneously. I will continue to work
gt; at it.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; =Countif(A:A,1) will count number of 1s in column A
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;SouthCarolinaquot; wrote:
gt; gt;
gt; gt; gt; I am trying to determine when I have repeats in a list of data. This is the
gt; gt; gt; situation:
gt; gt; gt;
gt; gt; gt; I have a list of data that contains numbers 1-99. I am trying to determine
gt; gt; gt; when the numbers 1 and 2 appear in the same list and then count those
gt; gt; gt; occurences. I have found a round about way of doing it, but do you know of a
gt; gt; gt; 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.

quot;Toppersquot; wrote:

gt; If the 1s and 2s are independent , then is not simply:
gt;
gt; =Countif(A:A,1) countif(A:A,2)
gt;
gt; OR
gt;
gt; =if(and(countif(A:A,1)gt;0,countif(A:A,2)gt;0),quot;both occurquot;,quot;only one or none
gt; occurquot;)
gt;
gt; Or have I completely missed the point (again!)
gt;
gt; quot;SouthCarolinaquot; wrote:
gt;
gt; gt; Thank you for your help. I can count the number of times the number 1
gt; gt; appears in the column with no problem. My problems start when I try to count
gt; gt; the number of 1's and 2's that occur simultaneously. I will continue to work
gt; gt; at it.
gt; gt;
gt; gt; quot;Toppersquot; wrote:
gt; gt;
gt; gt; gt; =Countif(A:A,1) will count number of 1s in column A
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; quot;SouthCarolinaquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am trying to determine when I have repeats in a list of data. This is the
gt; gt; gt; gt; situation:
gt; gt; gt; gt;
gt; gt; gt; gt; I have a list of data that contains numbers 1-99. I am trying to determine
gt; gt; gt; gt; when the numbers 1 and 2 appear in the same list and then count those
gt; gt; gt; gt; occurences. I have found a round about way of doing it, but do you know of a
gt; gt; gt; gt; 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 VezeridesI do that and I get a quot;#VALUEquot; error. Any suggestions.

quot;vezeridquot; wrote:

gt; Then you probably need something like:
gt;
gt; =SUMPRODUCT((A1:A100=1)*(B1:B100=2))
gt;
gt; HTH
gt; Kostis Vezerides
gt;
gt;

Try:

=SUMPRODUCT(--(A1:A100=1),--(B1:B100=2))

quot;SouthCarolinaquot; wrote:

gt; I do that and I get a quot;#VALUEquot; error. Any suggestions.
gt;
gt; quot;vezeridquot; wrote:
gt;
gt; gt; Then you probably need something like:
gt; gt;
gt; gt; =SUMPRODUCT((A1:A100=1)*(B1:B100=2))
gt; gt;
gt; gt; HTH
gt; gt; Kostis Vezerides
gt; gt;
gt; gt;