Get instant online expert help with Excel and Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
can't figure how to format a pivot table/chart the best way
Solved by I. S. in 28 mins
I have a budget per week per person, I want to be able to create a formula where if I enter a week number it will tell me the total remaining hours and costs for each person and then as a total.
Solved by E. H. in 25 mins
I have an excel file but its a bit sensitive.Now, i want a formula that checks for the customer deliveries and balances to be delivered.Once the column is delivered of course the balance to be delivered should be zero,then it cuts the whole column and removes it from that worksheet and transfers it to the fully delivered worksheet.
Solved by V. H. in 20 mins
We need to record a macro using the macro recorder:
a. Launch Excel Solver.
b. Click Reset All to reset the Solver model.
c. Set a target volatility level and maximize the portfolio expected return.
3. Modify the code so that your Solver can iterate through a range of target portfolio volatilities to generate the efficient frontier.
Solved by X. Y. in 18 mins
trying to add a specific picture based off value on cells
Solved by M. D. in 20 mins
How do I delete duplicates in an SQL database using an SQL query?
Solved by K. H. in 28 mins
1. HOW DO I FUNNEL OUT DUPLICATES ON AN EXCEL WORKSHEET?
2.
NEED TO REFORMAT AN EXCEL MASSIVE LIST
Solved by S. W. in 14 mins
can we find the maximum number for alpha numeric character for example SPL-1,SPL-2,SPL4,SPL8, SPL-9 & SPL-10. i want to get the answer as 10.
Solved by B. A. in 14 mins
Hi! I am trying to create groups in excel so I can later make a macro and have different students in them. For example I have 50 students and I want them in 5 groups, how can a randomly sort students in them?
Solved by D. E. in 17 mins
I purchased a new computer and the format has changed. don't know how to sort my logs? I need to sort columns by driver and dates?
Solved by D. H. in 13 mins