Closed

Total each customer then sort keeping all customer data together based on largest total - open to bidding

Clmn A Clmn B Clmn c Clmn D Clmn e

Cust # or Cust # with Site # Lift charge Haul Charge Total Charge Customer address

002 Toms Flower Anywhere US

002-2345 Sandy Smith $40.00 $30.00 $70.00

002-2348 Jack Bower $25.00 $20.00 $45.00

008 Jacks Electrical Anywhere US

008-1567 Restaurant $15.00 $35.00 $50.00

008-1723 Retail Place $35.00 $10.00 $45.00

This is how my spread sheet basically looks. You have the master account listed above the site location however some times (because I combined several reports you may get 2 or 3 site names with the same master account number(with data to the side) listed above the master then the site accounts below. Unfortunately they did not give a few site numbers but just used the same customer number. Like this:

009 Jims Gasket $20.00 $15.00 $35.00

009 Jims Gasket Anywhere US

009-4345 Sundial $40.00 $30.00 $70.00

002-1348 Auto $25.00 $20.00 $45.00

The master account and address is always in bold with just the name and address. I it has a total out beside the site name or master name then its a site address. Unfortunately the company I got the date from didn't use the site address account some times and the example above occurred.

Here is what I need

I need a total of all the site accounts for that customer so it would look like this.

002 Toms Flower Anywhere US

002-2345 Sandy Smith $40.00 $30.00 $70.00

002-2348 Jack Bower $25.00 $20.00 $45.00

$65.00 $50.00 $115.00

008 Jacks Electrical Anywhere US

008-1567 Restaurant $15.00 $35.00 $50.00

008-1723 Retail Place $35.00 $10.00 $45.00

$50.00 $45.00 $95.00

009 Jims Gasket Anywhere US

009 Jims Gasket $20.00 $15.00 $35.00

009-4345 Sundial $40.00 $30.00 $70.00

002-1348 Auto $25.00 $20.00 $45.00

$85.00 $65.00 $150.00

Then I need to be able to sort my groups together with totals so I can see who my best customers are so that it would look like this largest to smallest.

009 Jims Gasket Anywhere US

009 Jims Gasket $20.00 $15.00 $35.00

009-4345 Sundial $40.00 $30.00 $70.00

002-1348 Auto $25.00 $20.00 $45.00

$85.00 $65.00 $150.00

002 Toms Flower Anywhere US

002-2345 Sandy Smith $40.00 $30.00 $70.00

002-2348 Jack Bower $25.00 $20.00 $45.00

$65.00 $50.00 $115.00

008 Jacks Electrical Anywhere US

008-1567 Restaurant $15.00 $35.00 $50.00

008-1723 Retail Place $35.00 $10.00 $45.00

$50.00 $45.00 $95.00

So summing up I guess I need some way to total each customers totals then after this is done be able to sort the groups based on the largest customer grouped total?? How much to do this and how long will it take? Can you write the formulas and or macros to accomplish and send to me? I can send you one page from my file to work with.

Skills: Data Entry, Data Processing, Excel, Facebook Marketing, Internet Marketing

See more: what need to be done in marketing, sort sort sort, sort sort, largest number, jack smith, how to get out of retail, how to do reports, how do you write reports, cust write, b. e. smith, best way to get out of work, data entry master marketing, total it, restaurant marketing, master data, just jack, jacks, d flower, bower, bidding formulas

About the Employer:
( 0 reviews ) United States

Project ID: #5234413

8 freelancers are bidding on average $29 for this job

rgexpressindia

This is a silly task and I have done numerous like this. So I have quoted for least amount and time Also you can check my completion rate

$20 USD in 1 day
(1 Review)
0.4
deepakkumarkm

I am a student of Information technology doing my last year. I have good skills on calculation and I have software support for doing this project too. I can complete this on time with perfection.

$15 USD in 1 day
(1 Review)
0.3
alitariq1991

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)
0.0
ryan05

I had already observed your project and understood what you need, Looking forward for your positive response regard Ryan

$25 USD in 2 days
(0 Reviews)
0.0
LizKolb

I'd be happy to help you out with this, I just have a few questions. Is this a one-time task for you or will you have to do this repeatedly with fresh data? If this is a one-time deal, it sounds like simply getting the More

$25 USD in 1 day
(0 Reviews)
0.0
mdhasan100

A proposal has not yet been provided

$33 USD in 7 days
(0 Reviews)
0.0
manishrochwani89

Working expereince in excel..will b able to finish job in 5 days...send me a page of ur sheet on my email

$55 USD in 5 days
(0 Reviews)
0.0
mgdotcom

Please provide me with the sample data you require totalled and arranged in decending order and I will process for you.

$25 USD in 1 day
(0 Reviews)
0.0