how to find duplicate numbers?

[Melt]

I have a sets of data that goes:

000 820 2184
123 421 8952
and so on.. am i able to set a command/function that can prevent duplicate
sets at columns and rows level ( as in all 10 numbers)?

hope this is clear enough.. thnx !

Cheers,
Melanie

 

[Max]

One way for this:

.. set a command/function that can prevent duplicate
sets at columns and rows level ...?

Assume input range is A1:C3
Select the range A1:C3 (with A1 active)
Click Data > Validation
Allow: Custom
Formula: =COUNTIF($A$1:$C$3,A1)<2
Click OK

Test it out .. the validation will reject any attempt
to input duplicates anywhere within A1:C3
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---