is there a way to find similar cells within a column
So i have a list of names some of them has middle name some of don't
So the common denominator between two cell will be to match a least two words out the cell in order to be a match and it must be in the same column
I don't know if this is possible to do
Thank you for any help
like this
Martinez L Pedro
Martinez Pedro
Pedro Martinez lopez
Pedro Martinez l
Pedro Martinez
Last edited by martinez_pedro; 05-12-2011 at 10:03 AM.
Hello Pedro,
Do you have an actual name list that you can post?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Here is the file with some sample names Thanks Leith Ross
Hello Pedro,
Thank you for posting the workbook. What do you want to do once a possible match has been found?
I would like to group the possible match this way it will be easier to see the finding
Thanks
Hello Pedro,
Can you give me an example of what a grouping would like?
i attach a workbook so you can see what i mean by grouping the possible match together
Hello Pedro,
That answers my question perfectly. Thank you. Now to start coding.
Hello Pedro,
This macro will place the groups on the active worksheet starting in cell "E2". There is button on the sheet to run the macro. Each group is separated by a blank line.
Please Login or Register to view this content.
Thank Leith Ross it works really perfecly
Now if can just have your brain to be able to write macros like you I would be all set LOL
Thanks Again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks