Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2018, 06:15 AM
Rajesoz Rajesoz is offline Removing duplicate cross-reference entries in an index Windows 7 64bit Removing duplicate cross-reference entries in an index Office 2010 32bit
Novice
Removing duplicate cross-reference entries in an index
 
Join Date: May 2018
Posts: 4
Rajesoz is on a distinguished road
Question Removing duplicate cross-reference entries in an index

Hello,

I have created an index using entries thanks to the "References" menu. For some entries, I used the "Cross-reference" option instead of displaying the current page number.
If two entries are the same, and with the same cross-reference, each cross-reference is still displayed in the index.

Is there a way to remove the duplicate cross-references in an index, without deleting manually each redundant entry ?

My index currently looks like this:
atom, 12, 28
electron, 22, 31, 35
neutron See nucleon, See nucleon
nucleon, 13, 21, 30, 41
proton See nucleon, See nucleon, See nucleon
radioactivity, 4, 11
What I want it to look like:
atom, 12, 28
electron, 22, 31, 35
neutron See nucleon
nucleon, 13, 21, 30, 41


proton See nucleon
radioactivity, 4, 11
Thanks in advance !
Reply With Quote
  #2  
Old 05-18-2018, 09:37 AM
Charles Kenyon Charles Kenyon is offline Removing duplicate cross-reference entries in an index Windows 10 Removing duplicate cross-reference entries in an index Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Creating a proper index is a time-intensive task. This is true no matter which software you use.
See John McGhie's page: http://word.mvps.org/faqs/formatting/Createindex.htm

Word does not contain any built-in method to take out redundant entries you've made. I'm sorry.
Reply With Quote
  #3  
Old 05-18-2018, 02:17 PM
slaycock slaycock is offline Removing duplicate cross-reference entries in an index Windows 7 64bit Removing duplicate cross-reference entries in an index Office 2016
Expert
 
Join Date: Sep 2013
Posts: 256
slaycock is on a distinguished road
Default

It should be straightforward to write a short macro to do what you want. Can you post a word document with a sample of your index. It doesn't matter if the sample shows errors as it is the field codes that are needed
Reply With Quote
  #4  
Old 05-18-2018, 03:46 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Removing duplicate cross-reference entries in an index Windows 10 Removing duplicate cross-reference entries in an index Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,871
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Index entry fields (XE) are formatted as hidden, so if you display hidden text you should be able to locate the duplicates. It is rather straightforward, unless there are many more duplicates than your example suggests, of course, in which case Find & Replace may be helpful.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #5  
Old 05-18-2018, 03:48 PM
macropod's Avatar
macropod macropod is offline Removing duplicate cross-reference entries in an index Windows 7 64bit Removing duplicate cross-reference entries in an index Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Do be aware you cannot simply delete entries from the Index itself; as it is a field, the deleted entries will be reinstated immediately anything causes Word to refresh the field. You will need to delete the unwanted XE fields from the body of the document itself, then refresh the Index.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
cross-reference, entries, index

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? jsisley Excel 1 07-21-2017 09:20 AM
Macro for removing cross-reference fields with specific contents Ulodesk Word VBA 5 07-13-2017 08:27 AM
Removing duplicate cross-reference entries in an index alphabetize a list (manual index) with entries and sub-entries shmu Word 5 08-01-2016 11:15 PM
Removing duplicate cross-reference entries in an index Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
Removing duplicate index entries Bengt Word 5 03-01-2013 02:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft