176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

excel help
Sign in to Add to Watch List

IT & Programming > Data Analysis

View Change History

The client has made the following changes to the job.

Description
Date

Bidding period ended early.

Mar 10, 2014

Job awarded.

Feb 25, 2014
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Feb 24, 2014
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Hey guys,
I'd be happy to pay you a few bucks for this but I have a feeling there are some excel gurus out there that can literally give me a formula in 10 seconds to solve this so I'll cross my fingers. Below is a VERY small piece of a VERY large list. I need to basically aggregate the data and sum it up.

ie. I need to know how many
subscription plan 1
size S
box number 1

Then how many sub plan 1
Size M
box 1

The data types are as follows

Subscription Plans
1,3,12,24,36
Size
S, M, L, XL, XXL, XXXL, XXXXL
Box
1 - 15

So there are LOT of combinations

if you could write a little macro? or even just an aggregating function that I could drag down, I would appreciate it. Again, I'd be happy to pay a little, but if this is a tiny job, would keep you in mind for future work. Thx.



Last Name_ Subscription Plan_ Female Size_ Box Number
Ames 3 XL 7
Scott 3 XL 2
Marble 1 M 2
Pharris 3 M 3
Wal...

Sign in or Register to see more

Desired Skills
Microsoft Excel
Job ID: 53519224
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Pawan K.      
Pawan K.'s identity has been verified.  Learn More
 India  |  
I have got over 7 years of experience in web. development. The key skills include Python/Django, JAVA/J2E and core php. The database experience is...
7
  |  
 4.5   |  Private   |  6 Jobs
Bid ID: 54047148  |  Submitted: Mar 8, 2014 06:45 ET 
Proposal SEALED

 Germany  |  
Scientist turned marketer. Specialised in data analysis and data mining for small business. Extensive experience in biotech
3
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 54021250  |  Submitted: Mar 7, 2014 12:35 ET 
Proposal SEALED

 Vietnam  |  
Careful, reputation is the most important factor
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 53946135  |  Submitted: Mar 6, 2014 01:31 ET 
Proposal SEALED

Galton Wechsler      
Galton Wechsler's identity has been verified.  Learn More
 India  |  
Master of Computer Applications (MCA) Degree Holder with 6 years of Experience in Software Development and in Data Analytics.
2
  |  
 0.0   |  Private   |  1 Jobs
Bid ID: 53927809  |  Submitted: Mar 5, 2014 15:03 ET 
Proposal SEALED

 Italy  |  
electronic engineer expert in report, forecasting,data analysis an data mining. Also working in geocoding and mapping applications. Excel and...
3
  |  
 5.0   |  $120 Earnings   |  3 Jobs
Bid ID: 53869689  |  Submitted: Mar 4, 2014 13:35 ET 
Proposal SEALED

 United States  |  
I am a manager at a large transportation company and do most of the difficult operational analyses for the company. I have developed many Excel...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 53801773  |  Submitted: Mar 3, 2014 08:56 ET 
Proposal SEALED

John Plant      
John Plant's identity has been verified.  Learn More
 Australia  |  
I have over two decades experience in data extraction, manipulation, analysis and reporting. I can help you to produce effective reports and make...
8
  |  
 5.0   |  $1,761 Earnings   |  14 Jobs
Bid ID: 53722334  |  Submitted: Mar 1, 2014 00:46 ET 
Proposal SEALED

 India  |  
We are team of 6 professional as well as highly talented developers working ethically form last 3 years. We are known for our best because, “we...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 53655260  |  Submitted: Feb 27, 2014 12:07 ET 
Proposal SEALED

Vlada D.      
Vlada D.'s identity has been verified.  Learn More
 Serbia  |  
8+ Years of experience in Excel Macro and VBA development. I have developed over 1000 Excel Macro till now. Creating Excel Macros is like a fun...
5
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 53651029  |  Submitted: Feb 27, 2014 10:33 ET 
Proposal SEALED

 United States  |  
I have over 10 years of administrative and clerical experience, including 5 years at the Executive Level, 5 years as a reporting analyst and...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 53616773  |  Submitted: Feb 26, 2014 16:43 ET 
Proposal SEALED

 Bangladesh  |  
Working as a freelancer ever since completing a Masters degree in Interactive Multimedia Education from Victoria University, Melbourne, Australia....
6
  |  
 4.9   |  $1,696 Earnings   |  18 Jobs
Bid ID: 53593286  |  Submitted: Feb 26, 2014 07:29 ET 
Proposal SEALED

Tejas T.      
Tejas T.'s identity has been verified.  Learn More
 India  |  
4+ Years of experience in Excel Macro and VBA development. I have developed 300+ Excel Macro till now. Creating Excel Macros is like a fun for me....
10
  |  
 4.9   |  Private   |  225 Jobs
Bid ID: 53575408  |  Submitted: Feb 25, 2014 23:18 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »