View Single Post
  #1   Report Post  
BenBlair
 
Posts: n/a
Default Preventing Duplicate Cells

We have a list of about 8600 different numbers which are our accounts. Each
is 16 digits long. We have recently had the problem that when we copy over
account lines, sometimes we create duplicate cells. We need to prevent this
duplication. Is there any way in Excel to prevent the addition of cells that
have the same content?