Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find repeated data and remove (excel)

    Hello,

    I have a list of serial numbers, I want to load them into a map. The problem is I have repeating serial numbers. Is there a function which can find the repeats and delete them?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find repeated data and remove (excel)

    See Steve's replt in the thread starting at <post#=408971>post 408971</post#>

    The thread starting at <post#=497396>post 497396</post#> contains various method that can also be used.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find repeated data and remove (excel)

    There are tools in the 'Range' and 'Rows/Columns' bits of ASAP Utilities which will do this automagically.
    Probably not worth the bother in the case of samll ranges. Your choice.

Posting Permissions

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