Find Jobs
Hire Freelancers

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

$10-30 USD

Cerrado
Publicado hace más de 10 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 5234413

Información sobre el proyecto

8 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
8 freelancers están ofertando un promedio de $29 USD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,3
0,3
Avatar del usuario
A proposal has not yet been provided
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I had already observed your project and understood what you need, Looking forward for your positive response regard Ryan
$25 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 data to match line after line and then inserting a pivot table which will give you the summations you're looking for. If you will be doing this again and again with the same combined reports, a macro would help to quickly order the data for you. I can help with that also. What version of Excel are you using? My day job is accounting and I work with a lot of reports that come over to Excel from outdated software and I have to tweak the documents before I can really work with them. I'm certain that I can help you get the information you need out of the reports you're working with. I look forward to hearing from you and good luck with your project!
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$33 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please provide me with the sample data you require totalled and arranged in decending order and I will process for you.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde dic 16, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.