View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Eliminate List Duplication

Let's say your data is in A1:A100. Select A1:A100 and click
Format/Conditional Formatting

Formula Is: =COUNTIF($A$1:$A1,$A1)1

then select whatever format you want. Modify as needed.


"FX 2000 Inc" wrote:

Does Excell have a built in feature that can find, alert or highlight
duplicate email addresses from of master email files?

If not, can anyone recommend a software program that can filter duplication
from an Excel file list?