Excel Task - Alternative to using INDIRECT Function to pick up a sheet name from a tab and use it within a formula. Also using a named range containing the sheet names in a formula SUMPRODUCTS to sum across the selected sheet names
£20-250 GBP
Pagado a la entrega
I am looking for an Excel expert who can help me with a complex formula implementation. I need an alternative solution to using the INDIRECT function to pick up a specific sheet name from a tab and use it within a formula. Additionally, I want to use a named range containing the sheet names in a formula SUMPRODUCTS to sum across the selected sheet names.
Skills and experience needed:
- Advanced knowledge of Excel functions and formulas
- Experience in finding alternative solutions to using the INDIRECT function
- Familiarity with using named ranges in formulas
- Ability to work with complex formulas and calculations
Please note that I may need assistance with other Excel functions apart from SUMPRODUCTS and INDIRECT, but I am not sure at this time as it depends what you need to use to accomplish the task.
Ideally I'm after a formula based answer as the size of the spreadsheet means I'd rather not use VBA to edit formula based on the selections (for example).
Nº del proyecto: #37470541
Sobre el proyecto
Adjudicado a:
19 freelancers están ofertando un promedio de £127 por este trabajo
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Más
Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tabl Más
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Más
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc Más
Hello Mark S., Good afternoon I have read the project description, and I am convinced that I am the best person to help you. I have skills in Data Processing, Excel and Visual Basic. I have worked in many projects Más
Hi sir, I have a lot experience I can be the best for your project. I have a experience of more than 06+ years of Data Entry in Government Departments. I will do this project without any mistake. You can trust me. Ple Más
Hey! Greetings from Wilfred! After thoroughly reading the job description of your Excel Task - Alternative to using INDIRECT Function to pick up a sheet name from a tab and use it within a formula. Also using a named Más
Hi There, My name is Khushboo. Thank you for inviting me to apply for this job. I am a very hard worker who’s in serious need of a job. I’ve been going through some difficult times and I am willing to do anything to g Más