Hi. I use excel to hold lists of phone numbers for telemarketing. I'm currently using the semi-manual way of CTRL F to find duplicate numbers.
I've been told that there is a formula you can set up that will detect and highlight duplicate entries within a specified column. I was wondering what is the formula, and how do i set it up?
Thanks
Victoria
Bookmarks