Hi All!!!
Does anyone have any good examples of how I can use the MYEXTRACT
function as part of a macro and not just as a function?
I'm trying to extract a word or phrase found somewhere in column A
with a string found in column somwhere in column "B". In my true use
of the function, I have 12,000 rows of data to match.
For example:
A1: Dog
A2: Cat
A3: Man
A4: Woman
B1: The dog bark up the tree
B2: The man-hole was deep
B3: I saw the catwoman movie
B4: I love movies
Expected results (or something close)
C1: dog bark
C2: catwoman
C3: man-hole
C4: catwoman
I was using '=OFFSET(MATCH("*"&MID($B9,1,FIND(" ",$B9)+4)&"*",0)-1,0)
however it case sensitive and if I'm not mistaken MYEXTRACT is not
case sensitive.
If someone can show me how to upload a file for an example, I will.
Any direction is helpful.
Thanks
Michael
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
