Hi,
I require a coloumn on my spread sheet to only accept unique values.
I have got it working on a single sheet of my workbook but would like it to be able to check that the value is unique across multiple worksheets.
The code I have so far is :How could I modify this to include the checking the values across another worksheet=COUNTIF($C$3:$C$1001,B2)<=1
(the cell numbers would remain unchanged from the initial worksheet)
Many thanks in advance!
Bookmarks