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