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
---
"Melt" wrote:
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