Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-27-2017, 06:49 AM
Alsadius Alsadius is offline Find matching values between 2 docs Windows 7 64bit Find matching values between 2 docs Office 2010 64bit
Novice
 
Join Date: Nov 2017
Posts: 25
Alsadius is on a distinguished road
Default

So they're totally unrelated documents, and you want a list of every word that appears in both?

IMO, strip the punctuation(find and replace to turn periods into nothing, commas into nothing, etc.), copy it into Excel, tell it to treat it as space-delimited text(so that every word will be in a separate cell) with document 1 in sheet 1 and document 2 in sheet 2. I'm assuming the text will all be vertical, so from A1 to A9999(or whatever). Then put the following formula in cell B1 of worksheet 1, and copy it down to the bottom: =IF(ISERROR(VLOOKUP(A1, 'Sheet2'!$A$1:$A$9999, 1, FALSE), "", A1))

Column B will then be a list of every word that appears in both. (To explain the Excel a bit, the VLOOKUP finds the text of that word on the second sheet, and the ISERROR strips out the errors you'll get when it doesn't find them, leaving only the text of the duplicates)

Alternately, there may be a Web utility that'll do it more easily.
Reply With Quote
 

Tags
matching values



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find matching values between 2 docs Find paragraph matching an expression in Word and exporting to Excel spreadsheet ballpoint Word VBA 23 03-23-2018 02:04 PM
Find matching values between 2 docs Matching the values in two columns A and B and to see if there are common values in both the columns Asadmir27 Excel 8 12-29-2016 12:06 AM
Find matching criterior in sheet 1 and copy to Sheet 2 Auto Excel Programming 3 03-19-2016 01:41 PM
Formula/function to return column names for matching values GiJoe81 Excel 1 06-27-2015 12:13 AM
find 2 values i a table to find the right prise Vibov Excel 1 01-11-2015 07:25 AM

Other Forums: Access Forums

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