Compare Excel Spreadsheets
Required skills: Spreadsheet, Excel
This should be easy for a spreadsheet guru!
1st .XLSX Spreadsheet: 14,071 rows of data, A-AM columns.
2nd .XLSX Spreadsheet: 14,058 rows of data, A-AF columns.
3RD .XLSX Spreadsheet: 4,262 rows of data, A-AF columns.
Primary Key among all files is the Sku column.
YOUR JOB==>
1. If a Sku exists in the 1st and 2nd spreadsheets, copy columns Z-AJ from 1st spreadsheet to columns AG-AQ of 2nd spreadsheet.
2. If a Sku exists in the 1st and 3rd spreadsheets, copy columns Z-AJ from 1st spreadsheet to columns AG-AQ of 3rd spreadsheet.
Additional Skus in 1st spreadsheet that do not exist in 2nd or 3rd spreadsheet should be ignored.
Data on all spreadsheets should not be altered in any way.
Also, the data is confidential so your bid means you agree not to distribute it or share it with anyone.
Thanks!
1st .XLSX Spreadsheet: 14,071 rows of data, A-AM columns.
2nd .XLSX Spreadsheet: 14,058 rows of data, A-AF columns.
3RD .XLSX Spreadsheet: 4,262 rows of data, A-AF columns.
Primary Key among all files is the Sku column.
YOUR JOB==>
1. If a Sku exists in the 1st and 2nd spreadsheets, copy columns Z-AJ from 1st spreadsheet to columns AG-AQ of 2nd spreadsheet.
2. If a Sku exists in the 1st and 3rd spreadsheets, copy columns Z-AJ from 1st spreadsheet to columns AG-AQ of 3rd spreadsheet.
Additional Skus in 1st spreadsheet that do not exist in 2nd or 3rd spreadsheet should be ignored.
Data on all spreadsheets should not be altered in any way.
Also, the data is confidential so your bid means you agree not to distribute it or share it with anyone.
Thanks!
Posted In:Excel |
Related projects:
MS Excel spreadsheets
br>
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
Excel spreadsheets need created based on other spreadsheets.
I have a set of existing excel spreadsheets.
I need a unique set of spreadsheets to be created similar to the original ones.
I have about 5 different ones.
PM me rate for each one, or estimated cost.
Thank you.
I need a unique set of spreadsheets to be created similar to the original ones.
I have about 5 different ones.
PM me rate for each one, or estimated cost.
Thank you.
DATA ENTRY CONSOLIDATION OF SEPERATE EXCEL SPREADSHEETS
T, number of employees, address, state, contact, industry, tel number, web address, name of bank, and comments. Some listings appear in more than one database. Some listings are incomplete eg no web address or phone number. I wish to consolidate all these into one large database, where I can easily search by sales revenue, EBIT, industry, state, no. of employees etc. Where possible the fields can be filled in through on-line research.
Web search information, and enter into Excel spreadsheets
on (agency name, mailing address, county, email) of all police departments, fire departments, and hospitals in Southern California (San Diego, San Bernardino, Riverside, Orange, Ventura, Los Angeles, and Kern counties). I can provide links to get started, but some web search will be required.
The other will have the contact information (name, mailing address, email) for all short line and regional railroads in the United States.
The other will have the contact information (name, mailing address, email) for all short line and regional railroads in the United States.
MS Excel spreadsheets
rrect accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
DATA ENTRY CONSOLIDATION OF SEPERATE EXCEL SPREADSHEETS
IT, number of employees, address, state, contact, industry, tel number, web address, name of bank, and comments. Some listings appear in more than one database. Some listings are incomplete eg no web address or phone number. I wish to consolidate all these into one large database, where I can easily search by sales revenue, EBIT, industry, state, no. of employees etc. Where possible the fields can be filled in through on-line research.
Need to combine 1 PDF document with 4 Excel spreadsheets int
Need to combine 1 PDF document with 4 Excel spreadsheets into a single workbook and also search www.perfume-worldwide.com and www.frangrancenet.com for pricing and photos, then add to workbook. Also need to add photos from website to the final combined excel workbook.
MS Excel spreadsheets
br>
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
MS Excel spreadsheets
rrect accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
Ms Excel Spreadsheets
em and record them to the correct accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
MS Excel spreadsheets
rrect accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
Excel Spreadsheets to be Merged
xcel spreadsheets (35) which contain data in various forms. Entries vary from 200 - 4500 rows in each individual spreadsheet. Each sheet may have duplicate data.
I need them to be merged into a template and then sorted for duplicate entries so the data is cleaned and can be made useful for a marketing campaign.
The information contained within the spreadsheets are highly confidential and this project is to be treated as PRIVATE.
I need them to be merged into a template and then sorted for duplicate entries so the data is cleaned and can be made useful for a marketing campaign.
The information contained within the spreadsheets are highly confidential and this project is to be treated as PRIVATE.
2 Excel Spreadsheets that will manipulate imported data
an average of current student completion as a percentage.
3. if last login date is greater than 30 days and/or the unit completion average =0%, it needs to be flagged somehow in red
4. all red flagged need to be sorted together
5. extra column created to capture contact date with student + capture comment in another column- changing color status
3. if last login date is greater than 30 days and/or the unit completion average =0%, it needs to be flagged somehow in red
4. all red flagged need to be sorted together
5. extra column created to capture contact date with student + capture comment in another column- changing color status
clean up a few excel spreadsheets
Easy and short project. Just need someone to clean up a few excel spreadsheets so that they match a template. Thanks, Zack
Excel Spreadsheets Using VBA
dder's thoughts at that time.
Additional files submitted: (Files are only available for logged in users)
e-Workpapers.xls
Additional files submitted: (Files are only available for logged in users)
e-Workpapers.xls
Product Uploading - Excel Spreadsheets - Simple Photo Edits
nsation:
$ 5 per 10 products entered paid through Paypal upon completion of any spreadsheets.
This is an ongoing position. Products will be needed to be uploaded on a weekly basis (50-100 products per week)
If you are interested, please message me and I will give you directions on completing a sample before hiring.
This is an easy job and I look forward to hearing from someone who is interested in helping out my company work flow!
$ 5 per 10 products entered paid through Paypal upon completion of any spreadsheets.
This is an ongoing position. Products will be needed to be uploaded on a weekly basis (50-100 products per week)
If you are interested, please message me and I will give you directions on completing a sample before hiring.
This is an easy job and I look forward to hearing from someone who is interested in helping out my company work flow!
Excel Spreadsheets need to be converted into software
I have 5 existing excel spreadsheets which need to be converted
into 5 seperate standalone desktop software applications.
PM for more info.
Thanks.
into 5 seperate standalone desktop software applications.
PM for more info.
Thanks.
Excel VBA Project - Database Driven Spreadsheets
g system.
When bidding on this project, only bidders with a detailed response will be considered, standardized comments such as "need work", "please PM" will not be considered.
Thanks
Michael
Will provide more details to qualified providers.
Regards,
When bidding on this project, only bidders with a detailed response will be considered, standardized comments such as "need work", "please PM" will not be considered.
Thanks
Michael
Will provide more details to qualified providers.
Regards,
Compare Excel .csv Spreadsheets
15,990 rows of data, A-AM columns.
2nd .CSV Spreadsheet: 20,951 rows of data, the same A-AM columns.
YOUR JOB==>3rd .CSV Spreadsheet: We need the difference between 1st and 2nd Spreadsheets in the same A-AM format (should be about 4,961 rows, assuming no deletions in 2nd Spreadsheet), without any alterations to the data therein.
Also, the data is confidential so your bid means you agree not to distribute it or share it with anyone.
Thanks!
2nd .CSV Spreadsheet: 20,951 rows of data, the same A-AM columns.
YOUR JOB==>3rd .CSV Spreadsheet: We need the difference between 1st and 2nd Spreadsheets in the same A-AM format (should be about 4,961 rows, assuming no deletions in 2nd Spreadsheet), without any alterations to the data therein.
Also, the data is confidential so your bid means you agree not to distribute it or share it with anyone.
Thanks!
Analysing data from Excel Spreadsheets
re have been 14 goals scored by both teams and the number of goals.
Basically, if thhere is someone out there who can get excel to do exactly what they want, then i can give you the requirement for each question and then you can code excel to perform the funtion.
Before you bid, please look at www.football-data.co.uk and look at the spreadsheets about the results in the past.
Please reply with "I can do it" so show you have read this.
Basically, if thhere is someone out there who can get excel to do exactly what they want, then i can give you the requirement for each question and then you can code excel to perform the funtion.
Before you bid, please look at www.football-data.co.uk and look at the spreadsheets about the results in the past.
Please reply with "I can do it" so show you have read this.
