matrixknow
IS-IT--Management
- May 3, 2007
- 78
I have a column with employee id's. Sometimes two or more employee ID's are double. I need to dedect if there are ID numbers that appears more then ones. If I found such a number I can copy that to an error sheet.
Has someone an idea for code or is there a build in function to handle this ?
the code should detect :
604168 (appears tree times).
Has someone an idea for code or is there a build in function to handle this ?
Code:
604168
604168
605661
604168
605759
the code should detect :
604168 (appears tree times).