Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count subset-totals in column
I have a column with data.
The data consists of incremental numbers: Column A 1 2 3 4 1 2 1 2 3 What I want to do in column B is count the number of instances of each subset. Result would look like this: Column A Column B 4 1 2 3 4 2 1 2 3 1 2 3 The largest subset consists of 9 instances. I tried reaching a solution using CountIf and nested If-statements, but without any luck. Anybody have any bright ideas? by the way 1: I do have the add-on morefucntions, but didn't recognize a usefull fuction in there either). by the way 2: I could replace the numbers with a single character if that would help simplify this issue. Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values from a Subset of a List | Excel Discussion (Misc queries) | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
How to enter symbols for subset or element of a subset in Excel? | Excel Worksheet Functions | |||
How to count uniques of a SUMPRODUCT subset? | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |