Thanks for that RagDyer. On the spreadsheet where the data was I inserted a
column and put the following code ina cell. =IF(COUNTIF($A$2:A2,A2)=1,A2,"").
this worked fine. As originally specified I wanted the code to be on a
separate worksheet, but obviously looking at the data worksheet. i used this
code =IF(COUNTIF(sheet1!$A$2:A2,A2)=1,A2,""). all it returns is zeros's.
tried a few things. Any ideas?
--
Regards vipa


"RagDyer" wrote:

Check out Chip Pearson's web site:

http://www.cpearson.com/excel/topic.htm

Scroll down to the D's and check out all the pages on "Duplicates", where
you can find exactly what you need.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"vipa2000" wrote in message
...
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