Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find Similar Words In An Excel Document
Hi!
I've checked a few threads on this matter, but they don't quite cover what I'm after. I have an Excel document with several columns full of words and numbers. I have a Master column, which contains the Initial List. (A) I want to compare all the remaining columns to A, but not to each other. So that for example; B,C,D,E,F,G all compare against A and highlight within themselves, any words that match anything in A. The Slave columns will continue to grow, so the Formula would be something that can be copied and pasted to new Columns with minimal change. Preferably something that checks the entire column, with no number limit, as the columns are of varying length. Any help would be really, really appreciated, and I hope I've explained myself well enough! Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell check flagging words I can't find in Excel | Excel Discussion (Misc queries) | |||
Find Similar | Excel Worksheet Functions | |||
find similar numbers | Excel Discussion (Misc queries) | |||
need to correct scanned document all i get is jumbled words | Excel Discussion (Misc queries) | |||
Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel |