Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
=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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
Then you probably need something like:
=SUMPRODUCT((A1:A100=1)*(B1:B100=2)) HTH Kostis Vezerides |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
I do that and I get a "#VALUE" error. Any suggestions.
"vezerid" wrote: Then you probably need something like: =SUMPRODUCT((A1:A100=1)*(B1:B100=2)) HTH Kostis Vezerides |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the number of repeats in a list of data?
Try:
=SUMPRODUCT(--(A1:A100=1),--(B1:B100=2)) "SouthCarolina" wrote: I do that and I get a "#VALUE" error. Any suggestions. "vezerid" wrote: Then you probably need something like: =SUMPRODUCT((A1:A100=1)*(B1:B100=2)) HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of cells in a list, e.g. H6:H12, J4, J7: | Excel Worksheet Functions | |||
How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |