| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting repeats of data
I am working on large data sets. I am trying to find an effective way to
build a table that shows how many times each ID number show (1 to 10 times). Also, there will be some times that I don't want to count the occurance of an ID (if there is a False in the adjacent cell). A Pivot Table does some of this but I don't know how to sort a Pivot Table by number of occurances. Also, I haven't been able to exclude the False from the "Count of ID" column in the Pivot Table. Thanks, Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste VBA repeats and repeats | Excel Discussion (Misc queries) | |||
| NO REPEATS | Charts and Charting in Excel | |||
| HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
| How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
| My Pivot total just repeats item data | Excel Discussion (Misc queries) | |||
Threaded Mode
