GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Data Manipulation Excel

  Trial project  Click here to post similar project

Data Manipulation Excel is project number 234599 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider msoftsolution)
Status: Closed
Budget: $30-250
Created: 03/07/2008 at 8:34 EST
Bidding Ends: 03/08/2008 at 8:34 EST
Project Creator: pierrek View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(4 reviews)
Description: I have 2 excel spreadsheets. One contains a list of date ranges and the second one lists dates. I need to loop through the 2nd list and check if the date is included in of the the ranges listed in the 1st spreadsheet.

For instance. File 1 looks like this:
1 2/1/2007 3/1/2007
2 4/1/2007 5/1/2007
3 5/1/2007 6/1/2007

File 2 looks like this:
1 2/15/2007
2 2/18/2007
3 5/2/2007

The result should look like this
1 2/15/2007 1
2 3/15/2007 1
3 5/2/2007 3

Thanks
Report violation
Job Type:
  • Excel
Database: (None)
Operating system: (None)
Bid count: 6
Average bid: $ 35

 

Related project
 
Nonpublic project #309196 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
milesf01
View PM Post PM
$ 40 0 days 03-07-2008 08:59 9.72/109.72/109.72/109.72/109.72/109.72/109.72/109.72/109.72/109.72/10
(29 reviews)
Will check it quickly.
julio1973
View PM Post PM
$ 50 1 day 03-07-2008 08:53 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
Hi i can do it over 4 hours. Regards
msoftsolution
View PM Post PM
$ 30 0 days 03-07-2008 09:21 9.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/10
(1 reviews)
Hi,we can do it
kushvyas86
View PM Post PM
$ 30 1 day 03-07-2008 08:51 (No Feedback Yet)
please see pm for details
jituharjai
View PM Post PM
$ 30 1 day 03-07-2008 09:17 (No Feedback Yet)
The job will be done with 100% accuracy in stipulated time.
nickolaus
View PM Post PM
$ 30 1 day 03-07-2008 10:00 (No Feedback Yet)
Hello. Depending on how exactly dates are stored in cells, it would take from 2 to 4 hours for me to do it. I already have experience with VBA in MSOffice.
Bid on This Project

 

[ Freelance ] [ Post Project Free ] [ GAF Top Users ] [ Website Design ]

What is GetAFreelancer.com? ( Read about the company )

Outsourcing is hiring an outside organization to perform services such as information processing and applications development. Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. Companies of any size have used our web services. A freelancer is an independent worker, not on salary, hired instead on a project basis. It's easy, fun and very affordable to outsource your project with our site.

Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start! GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects. Our escrow feature is developed to protect both buyers and sellers.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.