Solve an excel problem
Budget: $10 – $30 USD
I am looking for an Excel expert to help me with a data analysis problem. I have a large data set with over 1000 rows that I need to analyze.
Using Excel (or VBA), I want a reusable dashboard built that calculates all the various combinations of numbers that equal a specific amount. For example, from a list of 5,000 numbers I want to know all possible combinations that equal $1,236,254.16. See the attached files for an example of a data set and an example of what the output might look like. Preferably I want this to run on both Excel for Mac and Excel for Windows.
The ideal candidate must have experience in data analysis and be proficient in Excel.
Requirements:
- Strong knowledge and experience in data analysis using Excel
- Ability to work with large data sets (over 1000 rows)
- Familiarity with various data types (text, numbers, dates, etc.)
- Problem-solving skills to troubleshoot any formula issues that may arise
- Attention to detail in formatting and design
Deliverables:
- A solution to the data analysis problem in Excel
- Depending on the complexity of the solution, a detailed explanation or tutorial on how it was achieved may be required
If you have the necessary skills and experience, please submit your proposal.
Using Excel (or VBA), I want a reusable dashboard built that calculates all the various combinations of numbers that equal a specific amount. For example, from a list of 5,000 numbers I want to know all possible combinations that equal $1,236,254.16. See the attached files for an example of a data set and an example of what the output might look like. Preferably I want this to run on both Excel for Mac and Excel for Windows.
The ideal candidate must have experience in data analysis and be proficient in Excel.
Requirements:
- Strong knowledge and experience in data analysis using Excel
- Ability to work with large data sets (over 1000 rows)
- Familiarity with various data types (text, numbers, dates, etc.)
- Problem-solving skills to troubleshoot any formula issues that may arise
- Attention to detail in formatting and design
Deliverables:
- A solution to the data analysis problem in Excel
- Depending on the complexity of the solution, a detailed explanation or tutorial on how it was achieved may be required
If you have the necessary skills and experience, please submit your proposal.