Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing text in columns
Hi,
I tried to follow other postings but I cant seem to be bright enough, please help I currently have 2 columns (please keep in mind I will have more then 2) with titles of articles. I already downloaded all the text from column A and I want to see which other articles I need to download from column B. However some titles are in essence the same but titles are slightly off (see below) or some have the same title but have a , or / or €“ or an and For example column A €“ column B €śyin-yang€ť €“ €śyin and yang€ť €śhow to overcome fear€ť €“ €śovercoming fear€ť €śthe essence of marriage€ť €“ €śessence of marriage€ť is this possible to do or do they have to be identical? How do I adjust the formula since I will have more then 2 columns, lets say 4 or 5 in total if you have comments or suggestion as to alternatives i would appreciate them. Thank you so much, Lear |
#2
|
|||
|
|||
Try using a VLOOKUP, but use "true" at the end instead of "false". True will tell it to find the closest match, false means find an exact match. =vlookup(a1,b1:b65536,1,true) B1:B65536 tells it to look in column B, rows 1-65536 (adjust as necessary). If you need to search multiple columns, change the range (for example..you want to search in columns B-D..change to B1:D65536) HTH -Deb -- dfeld71 ------------------------------------------------------------------------ dfeld71's Profile: http://www.excelforum.com/member.php...o&userid=21452 View this thread: http://www.excelforum.com/showthread...hreadid=377488 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
Text To Columns | Excel Worksheet Functions | |||
How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions |