Compare two data "client" sets each with about 5500 rows for matches. There may be several matching factors in the data, "Account Name" may not always match... some aspects of address or zip code may in some cases. Identify in list B which rows match in both lists. Also provide a column of "possible" matches. Goal is to determine which Clients ...
I need a one page (double sided) spec sheet created for a line of products we offer. There are (3) different sizes of this product and all of the technical information is basically the same with the exception of size. All of the technical information is available online on the website of a large international manufacturer. Please do not copy/pas...
I need an Excel LOOKUP formula written that will allow me to look up a number that has leading zeros. Example "00182" and use that as a reference field to look into another Excel sheet to see if the corresponding number is also in that sheet and return a value if TRUE. This could also be done with a macro.
NEED A unique 2 page (1 page, double sided) spec sheet created. I will give you the technical details in the form of manufacturer details about the product at the web site. and its different sizes. There you can also download images and logos. I will also give you other documentation about our company and our positioning in the market. The out...
List of 350 names in Excel file (Sheet A). Identify which ones are also in a 9500 row Sheet B. If a last name matches, must check first name to verify identical or similar match. Identify the matches in an additional Sheet (C).
175 Evernote records in their proprietary .ENEX format Data from these records needs to be transcribed (cut/paste) into an Excel spreadsheet. Pictures in the Evernote record will be used to capture an email address, but they will not be put into the Excel spreadsheet. Experience in Evernote is requested.
Skills: data entry, microsoft excel, typing, evernote
I have two lists and I need to compare facility names and locations in one list and identify if they are in the other list. The first list is about 5200 rows long. The second list is larger, about 142,000 rows. In the 5200 row data I would use a small subset of the data. For example in the 5200 row data the field might contain "Mercy Gilbe...
I need a powershell script that will run on Windows server 2008 and monitor a text log file for a certain string "The data file is no longer open. Cannot continue.". It should check that log file once 15 minutes after each hour and 15 minutes before each hour/. When it finds that sting, it should terminate a running process called djeng...
Two PDF documents contain 3200 contacts in block format. Need these names, titles, city, state pulled off and inserted into Excel spreadsheet file. Research and populate street address and zip code into the spreadsheet as well.
I need a simple batch script written that will stop two Windows services (Windows server 2008) and re-start them. I need this script to run once a day, scheduled and I need it to be available to run from the Windows console, any time.
Skills: linux, amazon web services, windows
“Appreciated his approach to the project and willingness to meet my needs... which weren't 100% defined we we started. He was flexible and diligent in tackling my project. VERY responsive! ”
I have a spreadsheet that has a block address in one column and I need the address parsed into address line 1, address line 2, address line 3, city, state, zip, country. remove some character strings that I will specify.
Specific data for project:
There are 1700 rows in the spreadsheet