| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count the times a number occurs in a given criteria?
Example:
labels counts 216 28 68 2316 68 5 68 24 24 149 I need to derive a formula to calculate how many times a unique label occurs for more than 60 counts. The results should be something like: 216= 0 68= 1 24= 1 How do I do it? Thanks a million if anyone could help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
