Find Jobs
Hire Freelancers

Excel formula

$30-250 USD

Terminado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
In Excel (Apple numbers), need a formula to look at 4 cells, in 20 different rows (so 80 cells total), and identify the 3 cells that contain the highest numeric values, and then for those 3 cells, each has a different cell to look to if it was one of the top 3, and then taking those 3 numbers in the referenced cells and producing a result based on a rule as to what numbers are in the 3 referenced cells. This same type of formula would need to be modified 3 more times to do the same, but for top 5, 10 and 15 cells. Also would need to replicate each formula a few times just to change rows being looked at for cells.
ID del proyecto: 12164652

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 7 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
Hello, I would like to work on your project, I have great experience using Excel and macros, vba. I have had many similar work before. I would like to work on your sample file. Provide please further details. Thank you. Regards.
$50 USD en 2 días
5,0 (127 comentarios)
6,5
6,5
38 freelancers están ofertando un promedio de $82 USD por este trabajo
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD en 1 día
4,9 (321 comentarios)
7,9
7,9
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$150 USD en 5 días
4,9 (230 comentarios)
7,5
7,5
Avatar del usuario
Hello there! I would love to work on this project. I am a Qualified Chartered Accountant (CPA equivalent) with 5 years of experience in the field of accounts, auditing, taxation and financial management. I am currently pursuing CFA program, USA and have successfully completed Level 1. I have 8 years of rich experience in Microsoft Excel including working with financial modelling, dashboards and VBA. Please feel free to drop a message to discuss this project further. Best Regards, CA Raghav Bansal
$166 USD en 3 días
4,9 (95 comentarios)
6,5
6,5
Avatar del usuario
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$77 USD en 3 días
5,0 (116 comentarios)
6,5
6,5
Avatar del usuario
Could you send me the Excel spreadsheet please? I would like to take a look at the data and possibly give you sample formulas. Regards,
$35 USD en 1 día
4,9 (151 comentarios)
6,4
6,4
Avatar del usuario
Hello, I am Excel and VBA expert. Can I see the file? What is rule to produce a result "on those cells"? Please note that I have 100% completion rate and 5-star feedback on 50 projects.
$88 USD en 1 día
5,0 (93 comentarios)
6,0
6,0
Avatar del usuario
- Can build the macros to look for the 4 cells wihin the 80 cell range and bring up the max 3, max 5 etc. - - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions - extracting, modifiying mails in Inbox, retrieving calendar, tasks or scheduling. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.
$80 USD en 2 días
4,7 (48 comentarios)
6,0
6,0
Avatar del usuario
A proposal has not yet been provided
$77 USD en 1 día
5,0 (7 comentarios)
5,2
5,2
Avatar del usuario
Dear the client, It's super easy. why did they bid so high? My name is Hai, I'm an expert in VBA programing and excel template, contact me and, I'll offer the best price I'll also provide samples of my work upon request Best regards
$30 USD en 1 día
5,0 (31 comentarios)
5,3
5,3
Avatar del usuario
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$60 USD en 0 día
4,8 (71 comentarios)
5,5
5,5
Avatar del usuario
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$89 USD en 2 días
4,6 (43 comentarios)
5,5
5,5
Avatar del usuario
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating strings and numbers between sheets and using calculations. I have expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have done mostly this type of project in Excel VBA group. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
$45 USD en 3 días
4,8 (65 comentarios)
5,3
5,3
Avatar del usuario
A proposal has not yet been provided
$200 USD en 5 días
4,9 (22 comentarios)
4,5
4,5
Avatar del usuario
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Will accept the lowest amount, you think fair. Please do give me a shot. Awaiting your response. Thanks!
$100 USD en 2 días
4,9 (14 comentarios)
4,3
4,3
Avatar del usuario
Hi. I have over 15 years of experience working with advanced excel formulas and vba. I think your task can be completed within a few days. if you could send me mock data, i could create a quick draft and share with you.
$100 USD en 3 días
5,0 (3 comentarios)
2,3
2,3
Avatar del usuario
We have read your project Requirements and are keen on working on your Project We can send you samples of similar work done in past for your evaluation of our skills. We have in depth knowledge of working in MS OFFICE ( WORD EXCEL POWER POINT) VISIO, Adobe Photoshop Adobe Acrobat Professional , Adobe Flash, Adobe Illustrator , Indesign and Corel Draw We assure you that we will execute the work as per your specifications We will be grateful to you if you could give us the opportunity to work with you on this project Regards, Sudha
$30 USD en 2 días
3,2 (1 comentario)
0,6
0,6
Avatar del usuario
Dear sir, I am a PhD student and I am new in this field. However I have an excellent experience with Microsoft Office (Word, Excel, PowerPoint ....etc.), I can also type very quickly on the keyboard and I have the ability of data processing.I passed the BULLATS exam with Cambridge University and I want to improve myself. I will submit your business on time and with high quality. I hope you accept me. Best regards.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello I am harshil chotaliya, a Graphic Designer And Data Entry operator With Over 5+ year of experience,Thank you for the opportunity to submit our proposal , We are a team of design experts and very much confident with 5+ years of experiencing designing and creative logos, corporate identity, print and word excel powerponint data entry work,We will provide you a variety of design options so you can choose the best & have unlimited revisions you are completely satisfied,Please send a message and I will get in touch with you,I am believe in Long Term Healthy Business Relationship and provide 365 days Support. Best Regards, Harshil Chotaliya
$222 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! I am a corporate finance professional with an Ivy League degree (Yale University 2012). I’ve spent the last 4 years working heavily with Microsoft Excel & PowerPoint; I am quite capable of utilizing Visual Basic to automate reports, complex formulas, formatting, & just about anything else you could imagine in a file. Aside from my technical capabilities, I am seasoned veteran when it comes to financial forecasting, mining through large data sets, & projection modeling. If there are unique requirements or deadlines as part of this project, please let me know & I am happy to work around them to fit all your needs. I look forward to working with you! Matt
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned .I have checked your requirements.i have right skills to work on this assignmentWe find our expertise, skills and capabilities are perfectly blends with your project requirements because we have already worked on many projects. You'll love the whole layout, interface design , cross-browser compatibility and mobile-device-friendly interfaces that we design Our team has created over dozen of windows, and web based appliations iPhone/iPad games and apps, and over 10 Windows and Linux server APIs and security tools Don't waste any more time in your development We take care of all these things for you . Advanced custom coding for our clients. Anytime. [Removed for encouraging offsite communication which is against our Terms and Conditions.]. plz add me to discus I am ready to discuss with you Looking forward to hear from you. with best Regards
$194 USD en 6 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Lake Forest, United States
5,0
13
Forma de pago verificada
Miembro desde nov 10, 2016

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.