Results 1 to 5 of 5

Deleteting duplicates for unique values with matching row values

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2021
    Location
    Oregon
    MS-Off Ver
    Office 365
    Posts
    3

    Deleteting duplicates for unique values with matching row values

    Hey everyone, I have a question that may not have an easy answer and through searching have found no solution that matches my position.

    I have a list of IP address and corresponding values related to them in two colums.

    For solutions, just assume the data is in A2:B10000

    Example:
    IP 1 Value 1
    IP 1 Value 1
    IP 1 Value 2
    IP 2 Value 1
    IP 2 Value 2
    IP 3 Value 2

    Is there a way to find and delete the duplicate values for each IP while maintaining the unique values for each IP address?
    I know that I could split the table by individual IP address and use Delete Duplicates. This was what I did last time and it took hours because I needed the data that day, have hundreds of IP addresses, and didn't have time to do research.

    I appreciate any help and am somewhat familiar with MS Visual Basics if that would provide the most robust solution.
    Last edited by bobbysmith; 09-14-2021 at 02:59 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting unique values from duplicates
    By Jimmy2Times in forum Excel General
    Replies: 3
    Last Post: 11-02-2017, 06:35 PM
  2. List unique values matching a criteria that has duplicate values
    By Andrewjs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2017, 10:11 PM
  3. Replies: 11
    Last Post: 10-27-2016, 07:33 PM
  4. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  5. Replies: 6
    Last Post: 03-29-2012, 12:16 AM
  6. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 PM
  7. matching values in columns that contain duplicates
    By jellybean in forum Excel General
    Replies: 8
    Last Post: 08-14-2006, 09:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1