| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
table of # of rows with unique combos of values in 4 separated col
I have a spreadsheet such as the following
A 1 4 F A 1 4 F A 2 4 G A 2 4 G A 2 4 H B 3 5 M B 3 5 M B 1 4 F and want to create a table that shows how many of each unique combination are in my sheet. Count A 1 4 F 2 A 2 4 G 2 A 2 4 H 1 B 3 5 M 2 B 1 4 F 1 There are about 500 unique combinations, so I need to be able to generate the list automatically, and there are other columns in between with data I want to ignore. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values in a table | Excel Discussion (Misc queries) | |||
| Count of Unique Values in Table of data | Excel Discussion (Misc queries) | |||
| create table of unique values? | Excel Worksheet Functions | |||
| Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
Threaded Mode
