How do I set a formula in Excel so it will not allow me to enter duplicate
values on a worksheet? I have used the Data Validation tool before to set
the countif function on a particular column but how do I set it for the whole
worksheet?

Thank you.

Louise