Results 1 to 2 of 2
  1. #1
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Finding Duplicates (Excel 2003)

    I have a column of 'account numbers' that needs to be truncated to fit a specific field size in an application. This truncation tends to create duplicate values (account numbers). A column of several thousand numbers is difficult to 'eye' to discover an duplicates that may have been created.
    Is there a way to look at this column and identify any duplicates that I may have created.

    Thanks in advance!

    Skip
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Finding Duplicates (Excel 2003)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •