Home

Simple Text Searching Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-304499%22%20slang%3D%22en-US%22%3ESimple%20Text%20Searching%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304499%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20problem%20is%20simple%20in%20design%2C%20but%20I%20won't%20comment%20on%20the%20difficulty%26nbsp%3Bof%20execution.%3C%2FP%3E%3CP%3EIn%20summary%2C%20I%20need%20to%20match%20data%20from%20two%20columns%20of%20data%20with%20the%20corresponding%20data%20in%20a%20separate%20two%20columns%20of%20data.%20The%20data%20is%20just%20a%20text%20string%2C%20specifically%20the%20name%20of%20a%20company%2C%20and%20a%20location%20(city%2C%20state).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EManually%20I%20accomplish%20this%20by%20looking%20at%20the%20raw%20data%20here%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F63268iFB8C41675A9B8E49%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202018-12-19%2020.55.58.png%22%20title%3D%22Screenshot%202018-12-19%2020.55.58.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20first%20line%20I%20see%20that%20it's%20Company%20AAA%2C%20located%20in%20Washington%2C%20D.C.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20turn%20to%20the%20other%20set%20of%20data%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F63269iBF4A3CE735EAC64F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202018-12-19%2020.53.08.png%22%20title%3D%22Screenshot%202018-12-19%2020.53.08.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20company%20AAA%20is%20listed%20here%20AND%20the%20city%20for%20that%20particular%20company%20is%20as%20well%2C%20I%20delete%20the%20original%20row%20of%20data%20I%20started%20with.%20If%20not%2C%20I%20abandon%20the%20search%20for%20this%20first%20data%20set%20and%20move%20back%20to%20the%20raw%20data%2C%20and%20repeat%20for%20the%20next%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20way%20of%20another%20example%2C%20you%20will%20notice%20that%20Company%20C%2C%20in%20both%20Nashville%20and%20Memphis%20are%20in%20both%20data%20sets%20and%20therefore%20would%20be%20deleted%20from%20the%20first.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20the%20basic%20idea%20of%20several%20loops%20with%20nested%20conditional%20statements%20but%20I'm%20far%20more%20interested%20in%20having%20someone%20produce%20this%20straightforward%20macro%20for%20me%20instead%20of%20spinning%20my%20wheels%20learning%20this%20specific%20language.%20Obviously%2C%20I%20would%20pay%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20someone%20think%20they%20can%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304499%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emacro%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
docbrain
Occasional Visitor

My problem is simple in design, but I won't comment on the difficulty of execution.

In summary, I need to match data from two columns of data with the corresponding data in a separate two columns of data. The data is just a text string, specifically the name of a company, and a location (city, state).

 

Manually I accomplish this by looking at the raw data here:

Screenshot 2018-12-19 20.55.58.png

 

On the first line I see that it's Company AAA, located in Washington, D.C.

 

I then turn to the other set of data:

Screenshot 2018-12-19 20.53.08.png

If company AAA is listed here AND the city for that particular company is as well, I delete the original row of data I started with. If not, I abandon the search for this first data set and move back to the raw data, and repeat for the next line.

 

By way of another example, you will notice that Company C, in both Nashville and Memphis are in both data sets and therefore would be deleted from the first.

 

I understand the basic idea of several loops with nested conditional statements but I'm far more interested in having someone produce this straightforward macro for me instead of spinning my wheels learning this specific language. Obviously, I would pay for this.

 

Does someone think they can help?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies