Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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 10:01 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