+ Reply to Thread
Results 1 to 4 of 4

Merging duplicate entries in an index

  1. #1
    Registered User
    Join Date
    01-28-2018
    Location
    Canberra
    MS-Off Ver
    14.0.7
    Posts
    2

    Merging duplicate entries in an index

    Good Morning,

    I'm working on a publication index, and I need to create an index for the entire year's publication out of the individual indices exist for each journal.

    So far I managed to merge indices and sort them, but one issue remains:

    Let's say the term "annual report" has been repeated in several different pages of the journal over the year:

    Annual Report *E161
    Annual Report *E150
    Annual Report *E243, E260, E275, E284
    Annual*Report *E243

    (E161,E150, ... are page numbers)


    I need a way to detect duplicate terms in first column, and group the page numbers like this:

    Annual*Report *E161,*E150*,E243, E260, E275, E284,*E243

    Thanks for your advice in advance,
    K

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,663

    Re: Merging duplicate entries in an index

    Hi kasray. Welcome to the forum.

    Withe the understanding that Annual*Report is a "typo" and you intend consistency this array entered formula will do that.

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

    In F1 as in the below array enter this formula and fill across until you get blanks.
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    A
    B
    C
    D
    E
    F
    G
    H
    I
    1
    Annual Report
    *E161
    Search string →
    Annual Report
    *E161
    *E150
    *E243, E260, E275, E284
    *E243
    2
    Annual Report
    *E150
    3
    Annual Report
    *E243, E260, E275, E284
    4
    Annual Report
    *E243
    Dave

  3. #3
    Registered User
    Join Date
    01-28-2018
    Location
    Canberra
    MS-Off Ver
    14.0.7
    Posts
    2

    Re: Merging duplicate entries in an index

    Hi Dave,

    Thank you very much! and yes, those star signs are all typos.

    I've managed to follow your instructions and it worked


    Thanks,
    Kasra

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,663

    Re: Merging duplicate entries in an index

    Good deal!

    You are welcome. Thank you for the feedback.

+ 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. Help merging duplicate entries with unique information
    By wizelsnarf in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2014, 03:02 PM
  2. Merging Duplicate Entries
    By Alex_Avilla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2013, 04:19 AM
  3. [SOLVED] How to adjust Index to catch duplicate entries?
    By jgomez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2013, 10:29 AM
  4. Remove duplicate entries when merging 2 worksheets based on certain criterias
    By zicitron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 06:07 AM
  5. [SOLVED] Index and Match duplicate entries
    By pauldaddyadams in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2013, 07:04 AM
  6. Need to remove duplicate entries from an index
    By Lacaycer in forum Excel General
    Replies: 10
    Last Post: 04-04-2012, 10:50 AM
  7. Replies: 0
    Last Post: 09-18-2011, 06:48 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