+ Reply to Thread
Results 1 to 4 of 4

Finding Multiple Duplicates

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Coldstream Victoria Australia
    MS-Off Ver
    Microsoft Excel for Mac Version 16
    Posts
    21

    Finding Multiple Duplicates

    I have a spreadsheet with 7000 rows. Each row represents an item of music, ie. either a CD, Vinyl Disc or a Cassette
    Each row has an Object ID in column A. Column B is to input the Band ID
    There are then columns for each musician that is attached to each object. There may be ten to twelve musicians per object, but generally about 6.
    Many of the musicians have played in the same group or band, although the bands may have different names.
    I want to search the spreadsheet and define common groups of musicians and allocate a Band ID to those musicians.
    How do I go about this task in an automated format

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Finding Multiple Duplicates

    First thing that comes to mind is building a Lookup table with your groupings and then apply that in a Lookup formula to the data.

    See if one of these help...

    https://www.techonthenet.com/excel/formulas/lookup.php
    https://contexturesblog.com/archives...ays-16-lookup/
    https://contextures.com/xlFunctions02.html
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    09-14-2012
    Location
    Coldstream Victoria Australia
    MS-Off Ver
    Microsoft Excel for Mac Version 16
    Posts
    21

    Re: Finding Multiple Duplicates

    Thank you for the post. I am not certain a Lookup table can help, other than searching a row for other similar rows. But I need to automate the process.

    For example. Show Row 2 as the Look Up row, and then search Rows 3 to 6999, looking for identical rows. This would work for Row 2,
    However, I then need to search Row 3 for identical rows, and so on, up to Row 6999.

    I would like to automate the process

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Finding Multiple Duplicates

    Quote Originally Posted by georgiabrown View Post
    Thank you for the post. I am not certain a Lookup table can help
    Quite honestly, I'm not sure what you actually need either.

    Quote Originally Posted by georgiabrown View Post
    I would like to automate the process
    I think before we can do this...

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA for finding Duplicates-multiple sheet
    By prashanthng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2014, 08:39 AM
  2. Finding Duplicates Across Multiple Workbooks.
    By sturmy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2014, 10:49 AM
  3. [SOLVED] Finding Duplicates Across Multiple Workbooks.
    By sturmy in forum Excel General
    Replies: 0
    Last Post: 04-24-2014, 09:43 AM
  4. finding duplicates in multiple columns.
    By caseythomas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2014, 05:24 PM
  5. [SOLVED] Finding duplicates throughout multiple columns
    By goldstar1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 09:37 PM
  6. Finding duplicates in multiple columns
    By khank in forum Excel General
    Replies: 2
    Last Post: 12-30-2010, 06:54 PM
  7. Finding duplicates of multiple col's and moving
    By pauluk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 08:32 AM

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