| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count unique values and create list based on these values
I have the below data. Firstly, I don't want to use excels autofilters. My
data changes monthly. I want 2 worksheets, one that contains data pasted in by users, which will vary in length and the other worksheet functioning as a report sheet interrogating the data on spreadsheet 1. On worksheet 1 column 1 will have multiple entires but with many duplicates. I want the report sheet to count the number of unique values and count them, and now the tricky bit, generate a list displaying this data. I have in other reports set my column ranges as an example to a2:a30000. 1 2 120209 CONELECT 120209 CONMISGS 120209 CONMISGS 120215 CONBATT 120215 CONCAIRO -- Regards vipa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a legend of values | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
| create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
| How can I create a list that skips zero values? | Excel Worksheet Functions | |||
Threaded Mode
