duplication of data

[vino.spider]

hi friends,
i am new to excel but i know some thing about vb ..
now help me to find duplication of data with in a selected range ..
for ex:
range("a1:a6500")
it should accept only unique values



i need the code... and also the formulas
...

thanks in advance

 

[rudfaden]

try this link: http://spreadsheetpage.com/index.php/tip/identifying_unique_values_in_an_array_or_range/

 

[Peter_SSs]

Welcome to the MrExcel board!

Your question is not entirely clear. You say you want to find duplication but you also say it should accept only unique values. If it (whatever *it* is) accepted only unique values then there would be no duplicate values to find.

Tell us a bit more about exactly what you have and what you are trying to achieve.

Also, what version of Excel are you using?

 

[vino.spider]

only thing is range(A:A) should accept only unique values...
if not prompt with the msg...

 

[vino.spider]

thanks peter..
i am using excel 2003 ....
simple thing...
sheet1.range("a1:a55") should accept only unique values
thanks ...

 

[Peter_SSs]

Try this

1. Select A1:A55
2. Data|Validation...|Settings tab|Allow: Custom|Formula: =COUNTIF(A$1:A$55,A1)=1 |Error Alert tab|Enter a message if you want|OK

That should stop users entering duiplicates.

 

[vino.spider]

thanx peter...