Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2019, 06:10 PM
sylvio sylvio is offline check for duplicates of a word within next 100 words Windows 7 64bit check for duplicates of a word within next 100 words Office 2010 32bit
Novice
check for duplicates of a word within next 100 words
 
Join Date: Jan 2017
Posts: 20
sylvio is on a distinguished road
Default

Many thanks, I have changed the code according to your suggestion, but set j = 100.


Exclusion list looks like this now: |a|an|as|and|of|on|the|to|from|for|with|in|as|it|

I have checked the macros on the text with several dublicates, in total 98 words:
"The US is a federal republic comprising 50 states and state the Federal District of Columbia. It originated in the American Revolution, the successful rebellion of the colonies on the eastern coast against British rule in 1775-83. The original 13 states that formed the Union drew up a federal constitution in 1787, and Texas George Washington is elected the first president in 1789. In the 19th century the territory of the US was extended across the continent through the westward spread of pioneers and settlers and acquisitions such as that of Texas and California from the Mexico state."

In the attached image you will see that the macros does not find duplicates of "state" and "is". Manually through Find, Find all word forms, they all can be found easily.
Attached Images
File Type: jpg Capture.JPG (103.4 KB, 47 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
check for duplicates of a word within next 100 words Macro to check against Columns & Delete Duplicates cjamps Excel Programming 27 12-18-2017 06:38 AM
check for duplicates of a word within next 100 words how to check for duplicated words / cells ? iSlam Khaled Word Tables 11 05-05-2015 08:07 PM
check for duplicates of a word within next 100 words Adding words to spell check dictionary oakwoodbank Word 17 02-27-2015 08:09 PM
check for duplicates of a word within next 100 words Spell check adding words riweir Word 3 11-30-2011 09:03 PM
Edit spell check dic to exclude words? franklekens Word 1 07-03-2010 09:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:52 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