Get instant free 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
need help to make IRR or XIRR calc work. Some dates have a cashflow of zero.
Solved by B. Q. in 21 mins
Using Excel 2016. I have a Workbook that is tracking baseball bets. I have a sheet for each day. The columns are the same for each day but the number of rows can vary. I want to calculate the monthly profit totals. But that means I have to change the formula every day that I add a new sheet. Is there a way to do this without writing a macro.
Solved by C. S. in 11 mins
I am trying to hyperlink a name on one sheet to the same name on another sheet - but need a formula to search for that data on the second sheet
Solved by C. H. in 27 mins
In cell G8 in the Summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell F8). Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensure that the function you use displays that result.
Solved by S. Y. in 26 mins
I need an expert who can build an entire private equity/real estate waterfall sheet with our exact specifications
Solved by I. Q. in 23 mins
I need to create chart that creates stacked bar graph with many series that are not related
Solved by V. C. in 29 mins
Hello I need help with sorting my data on the first page
Solved by O. J. in 14 mins
I need help creating a formula involving assessing text.
Solved by E. L. in 19 mins
I was talking to someone. query with the ID problem/32658. Can we resume the work, please
I need a formula written into cells to identify patterns and then count specific data. The pattern data that first needs to be identified is spread across column B through I. The formula should first recognize the pattern within these cells. THEN according to the search criteria, the formula should match one of three values and produce a value of either (1) or -(7). The Sheets labeled 'SHOOPEE PATTERNS ONE ROW' and 'SHOOPEE KEY' are the active worksheets within the file attached that need the formulas pertaining to this project.
Solved by Z. U. in 28 mins
I have inserted checkboxes and its been working great, but not it will not let me check the boxes
Solved by A. L. in 22 mins