Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns of text
A colleague has asked me this, it's making my head hurt
I have two columns of text and I need to find out whether any of the data from the 2nd column (5000 entries) exists in the first column (47000 entries). But I also need it to tell me if it exists in part, for example if column 2 says "business advice" and column one says "where can i find impartial business advice?", then that should show as a match. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns of text
Look in the vba help index for FINDNEXT
-- Don Guillett Microsoft MVP Excel SalesAid Software "angela9000" wrote in message ... A colleague has asked me this, it's making my head hurt I have two columns of text and I need to find out whether any of the data from the 2nd column (5000 entries) exists in the first column (47000 entries). But I also need it to tell me if it exists in part, for example if column 2 says "business advice" and column one says "where can i find impartial business advice?", then that should show as a match. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns of text
http://www.j-walk.com/SS/excel/usertips/tip073.htm
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "angela9000" escreveu: A colleague has asked me this, it's making my head hurt I have two columns of text and I need to find out whether any of the data from the 2nd column (5000 entries) exists in the first column (47000 entries). But I also need it to tell me if it exists in part, for example if column 2 says "business advice" and column one says "where can i find impartial business advice?", then that should show as a match. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing text values in two columns | Excel Discussion (Misc queries) | |||
Comparing text within cells in two columns | Excel Worksheet Functions | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Comparing Two Columns of Text | Excel Discussion (Misc queries) | |||
Comparing text in columns | Excel Discussion (Misc queries) |