| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate how many instances of a number appear in a wksh
For instance, if I have a worksheet which has 3000 cells with difference
numbers in each, how can i report on how many cells contain the number 11, and so on? I want to report on around 50 numbers, and show how many times all 50 numbers appear in the worksheet in some sort of report. Would really appreciate it if someone could help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of instances | Excel Discussion (Misc queries) | |||
| Count the number of Instances | Excel Discussion (Misc queries) | |||
| In a set of dates, can you count the number of Jan '07 instances? | Excel Worksheet Functions | |||
| How to make a key float in an excel wksh when a person scrolls. | Excel Worksheet Functions | |||
| Counting number of instances before a certain date | Excel Worksheet Functions | |||
Threaded Mode
