Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2015, 03:58 PM
Guessed's Avatar
Guessed Guessed is offline how to check for duplicated words / cells ? Windows 7 32bit how to check for duplicated words / cells ? Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

There is no built-in option in Word to highlight duplicate 'words'. There is in Excel but you already discounted that suggestion earlier.

It appears that you are not actually looking for duplicate words but appear to be looking for duplicate cell contents.

We probably need to assume that you don't need to find multiple dose sizes (as alluded to by the contents of the first row) and that the first column of numbers is manually entered rather than being autonumbers, then a macro based on the following principles would do the job.

1. Sort the table based on column 2
2. Query the cell contents in column 2 and highlight the cells where the cell contents match the cell above.


3. Re-sort the table based on column 1 to get the table back in the original order
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 05-04-2015, 03:59 AM
iSlam Khaled iSlam Khaled is offline how to check for duplicated words / cells ? Windows 8 how to check for duplicated words / cells ? Office 2013
Novice
how to check for duplicated words / cells ?
 
Join Date: May 2015
Posts: 7
iSlam Khaled is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
There is no built-in option in Word to highlight duplicate 'words'. There is in Excel but you already discounted that suggestion earlier.

It appears that you are not actually looking for duplicate words but appear to be looking for duplicate cell contents.

We probably need to assume that you don't need to find multiple dose sizes (as alluded to by the contents of the first row) and that the first column of numbers is manually entered rather than being autonumbers, then a macro based on the following principles would do the job.

1. Sort the table based on column 2
2. Query the cell contents in column 2 and highlight the cells where the cell contents match the cell above.
3. Re-sort the table based on column 1 to get the table back in the original order
That's already what i do but i asked for simple way to do this !
Thank you very much for your help
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to check for duplicated words / cells ? Adding words to spell check dictionary oakwoodbank Word 17 02-27-2015 08:09 PM
how to check for duplicated words / cells ? Check for duplicated data and print list cjharley Excel 2 12-19-2014 11:44 PM
Words are being duplicated in text boxes argentraven PowerPoint 0 07-24-2014 03:10 PM
how to check for duplicated words / cells ? Spell check adding words riweir Word 3 11-30-2011 09:03 PM
Words are duplicated on print agentred Word 1 06-29-2010 08:45 AM

Other Forums: Access Forums

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


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