Find Jobs
Hire Freelancers

correct 2 excel formulas

£10-20 GBP

Terminado
Publicado hace más de 8 años

£10-20 GBP

Pagado a la entrega
2 Excel formulas need correcting, BOTH did originally work in the workbook I have uploaded here, because too big 9MB to upload to freelancer [login to view URL] 1....in the ignore worksheet AY is supposed to pick up data from tableExport J but isn't eg ignore AY11 should be showing tableExport J2 result -9 ( have highlighted the cells green to make it easier ) 2.....races sheet AL39 should be showing the results for Ayr AL38 same as AE39 to AK39 do for the names above
ID del proyecto: 8260478

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 9 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
Adjudicado a:
Avatar del usuario
Hi there! Have done this type of work before! I have downloaded and reviewed the Excel file, and have found the solution to Formula No.2, and am about to look for the solution to Formula No.1 . Please feel free to ping me with additional information or with questions if any! Thanks! -Steve
£12 GBP en 1 día
5,0 (74 comentarios)
5,5
5,5
17 freelancers están ofertando un promedio de £16 GBP por este trabajo
Avatar del usuario
Hello sir! I'm expert on data entry, data processing and have more experience in the sorting data. I'm very proficient in the use of spreadsheet, function, macro in Ms Excel. Please take a look at my profile on Freelancer to verify experience from the past projects. I'm available to start the work now and ready to complete the task within a few hours. Look forward to working with you on this project. Best regards, Giang
£17 GBP en 1 día
4,9 (302 comentarios)
7,2
7,2
Avatar del usuario
A proposal has not yet been provided
£15 GBP en 0 día
4,9 (285 comentarios)
6,6
6,6
Avatar del usuario
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
£20 GBP en 1 día
4,8 (72 comentarios)
5,8
5,8
Avatar del usuario
A proposal has not yet been provided
£13 GBP en 1 día
4,9 (55 comentarios)
5,9
5,9
Avatar del usuario
Hey, I have a lot of experience with Excel and VBA. I can probably fix it but you have a password on you Excel file. Send me a message for more info. Kind regards, Rens Slenders
£18 GBP en 1 día
4,8 (15 comentarios)
4,4
4,4
Avatar del usuario
Dear Valued Employer, We can add value to your project, by suggesting new ideas. We are fast and reliable. For further understanding why we are the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, We provide genuine and innovative solutions as per your circumstances and requirements. My Team comprises MBA-Finance, M.A-Economics, and Chartered Accountants, Financial Analysts, Software developers, Graphics Designers, Web Developers, Data entry operators, Research Associates, Report Writers, Content Writers and Communication experts. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Naveen
£18 GBP en 1 día
4,9 (19 comentarios)
3,9
3,9
Avatar del usuario
Hi i am navaneethan i with to complete this project before your deadline and this job is able to done before your target time
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
£15 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
£23 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Experience Marketing Analytics Professional in Sales and Retail domain in the areas of Reporting and Analysis. Hands on experience in SAS & R and Advance Excel. Exposure in Campaign Analytics, Customer Segmentation & Profiling. Good hands on experience in Data extraction, Validation and analysis of various Product market research & Consumer Analytics. Possess excellent interpersonal, analytical and team building skills with proven ability in establishing quality systems/procedures and planning deliverables and achieving targets on time or before time Technical Skills SAS Products: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/ODS [Data Extraction; Data Validation; Data Modification; Data Management; Data Analysis & Data Reporting using DATA & PROC Steps in SAS] Exposure to advanced analytics methodologies such as Regression(Linear,Logistic,etc), Cluster Analysis and Factor Analysis on Statistical data analysis tools like SAS/R Languages : SAS, SQL, Excel Tools : MS Office – EXCEL; POWERPOINT; WORD; OUTLOOK Operating Systems : Windows SAS BI Tools : SAS/Enterprise Guide
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
if you give me the chance, i can do it
£15 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
we will provide you solution with accurate. we can start soon.
£11 GBP en 1 día
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
I have tremendous experience in working with excel as I have amazing grasp on excel formulas and reports.
£10 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Greetings ! I have looked at your spreadsheet and solved both questions - for second question you need to clarify me a little bit more what you exactly need because this formula sumif has an error in calculation. I hope to hear from you soon!
£19 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I already solved the second problem , it was due to that you are comparing "AYR " to "AYR" ( first one has space at its end but second one doesn't. first problem I don't understand it well, may be if we took I could make it. freelance me... thanks Ahmed Mohsen
£18 GBP en 1 día
0,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Leeds, United Kingdom
5,0
25
Forma de pago verificada
Miembro desde mar 29, 2009

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.