hi jack,how to check if in a given column is there any duplicates
for example, i use customer info with each name in a separate row
and i want to check if i entered by mistake the same customer twice
Hi Jack,thats terrific, thanks so much
however, i want it in a function code, so that it will automatically tell me if there are any duplicates, also it should give me either the cell reference or the actual data that is duplicated, is there any way to get that?