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. |
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 |