I have some collection of my client telephone numbers and email address. How can I arrange it in order so that I can know if the same number or email address is repeating. I had tried out with the microsoft excel but I need to check it one by one after I had sort all the numbers in order. Please help. Thanks.
2007-08-08 18:19:04 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
Select the whole area that you dont want any duplicates. It can be an entire column.
Then - Format
Conditional Format
Formula
=countif($A$1:$A$2500, A1)>1
Select format - then change the font or whatever you want to do.
$A$1:$A$2500 = i took this area. you can change it.
Make sure A1 has no dollar signs.
If you have any duplicate entries (email/phone nos), they will all get highlighted.
2007-08-09 01:02:16 · answer #1 · answered by voyager 6 · 0⤊ 1⤋
Use Microsoft Access
2007-08-09 01:21:56 · answer #2 · answered by mdigitale 7 · 0⤊ 0⤋
Why don't you download one of the many free address book programs available? There are too many to mention, so you'll have to be the judge. Just enter free address book software in Google, but watch the ones that offer 30 day trial periods.
2007-08-09 01:29:07 · answer #3 · answered by John K 6 · 0⤊ 1⤋