I am checking duplicate entries on a speadsheet using the array:
if(Countif($A$1:A2,A2)>1,"Duplicate","")
Where data for checking is in Col A starting at A2
This works very well, but I now need to check against another worksheet as well, with data in same Col
any ideas would be appreciated
great forum