Here are some problems that our users have asked and received explanations on
I need to create a nested if formula to calculate a total, based on a code in one formula that calculates the end figure in that column.
Solved by M. H. in 28 mins
I need a copy of an Excel file exactly the same minus all inserted text , but with all styles and formulas intact. How do I do that?
Solved by A. L. in 24 mins
For an example, there are 2 (two) share holders in a business. £1,000 = 1 share. Share holder A bought 5 shares with £5,000 and share holder B bought 3 shares with £3,000. This means that they started their business with £8,000 Equity. After a while with all profits, the total equity reached £16,000. What is the correct Excel formula to calculate their revised number of share and their individual accumulated equity please?
Solved by V. U. in 19 mins
I am trying to make my vba code repeat infinitely and save to a pdf upon a condition being met. I want it to just look at the condition and save.
Solved by M. U. in 26 mins
Hi, I have a spreadsheet I would like to remove any links and code from it apart from the links in Column D
Solved by K. F. in 21 mins
I am having trouble doing a chitest or chisq test to get P-value on excel
Solved by C. A. in 22 mins
I need help with cohort analysis.
I have pasted an example of the chart we would like you to create. Please create a similar chart for the LTV of the February cohort. You can use all the data in the data set (so 2/15 through 3/16 - 13 month time horizon after the end of 2/15).
- the cohort LTV is segmented by customer type
- % of customers is the % of all customers in the cohort that are the customer type
- % of Rev is the % of gross revenue of the entire cohort (only the cohort's revenue) over the entire time horizon
- LTV (GMV) is the average LTV of the customer type
Solved by X. W. in 28 mins
I am trying to do work time sheets in excel. I am using 24 hr times and have got the hours per day but when i try to total the full hours spent on a job that may last for 2-4 weeks it is not adding up the column correctly. can you help
Solved by V. H. in 27 mins
three columns - status (1,2,3), salary (#), title (1,2,3,4,5).
i am trying to work out the min for all individuals with a status of 1 or 2 and that have a title or 1,2,3 or 4
Solved by D. C. in 12 mins
Copied data from a website horizontally but it pastes vertically in excel