-
Posts
46 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by john.grisum
-
-
Ive slimmed down to the PRD & # of hits columns. This makes it much easier for me to focus on which PRDs are good and which are not.
-
I have a little side project that I need to complete and would like some input. I have a list of about 3,000 excel entries that i need to find their matching sibling (I currenlty have over 11,000). I have included examples below where the MEP has a sibling PRD. MEP-04103-001 PRD-49028-005MEP-04103-001 PRD-49028-006MEP-04103-001 PRD-49028-007MEP-04103-001 PRD-49028-010MEP-04103-001 PRD-49028-011 I have several thousand PRD numbers that do not have their sibling MEP numbers and would need to search the web for such a match. I have been doing this manually but I will have several hundred to do each month and it will become quite tedious. I have been doing manual web searches by using this format: "PRD-09854-019" NEAR "MEP-*****-***". What I need is to be able to create an excel or similar document to include web searches for the PRD and include perhaps the top 5 results' description section and web link. Any ideas would be greatly appreciated.
- 1
-
Why this thread is pretty much dead! Lets start it up again!Site Name: Free My BlackberrySite Description: Offers FREE Unlock Codes for GSM Blackberry phones.Site Owner/Developer: me/ some helpersSite Address: Freemyblackberry.comExtra Comments: Good? YES/NO. Suggestions... Comments?Any suggestions on decreasing load times?
Multiple Google Searches to Excel (or Similar)
in General
Posted · Edited by john.grisum
Just an update. I have used a VB script via excel to undergo a search for the content in A# and display the number of hits in B#. It actually works quite well. The code is below if anyone wants to use it. Example output: [A1] "PRD-12345-123" [B1] 708 Hits