Here are some problems that our users have asked and received explanations on
I have two columns in an excel pivot table. Both columns are showing data as a percentage of the column total for seperate years. I'd like to show the share change between years. i.e. Brand A had 35% in 2017 and 25% in 2016 so it grew 10% from 2016 to 2017. Is it possible to make this calculation within the pivot table?
Solved by G. F. in 11 mins
Hi - I have a 2013 excel file with 3 tabs. It is protected from editing. It has a few connections that ar refreshed using vba in ThisWorkbook, which unprotects - refreshes - opens workbook.
I want a button to save a copy of this workbook that has no protection and the data connections are disconnected.
Solved by M. C. in 30 mins
use the excel sheet name part 2 to answer the question and round the answer to 4 decimal places . Information from the American institute of insurance indicates that mean amount of life insurance per household in the united states is $100,000 with a standard deviation of $40,000 assume the population distribution is normal. A random sample of 100 household is taken
What is the probability that sample mean will be more than $120,000?
What is the probability that sample mean will be between $100,000 and $120,000?
Solved by B. Y. in 21 mins
I want to create a function that will get the age of a certain birthday with this format "1 year 2 months & 3 days"
Solved by G. L. in 21 mins
I'm merging two databases and need to remove or flag rows from Database 2 if the column (email domain) is present in Database 1.
Solved by T. H. in 14 mins
Question on a SUMIF formula: =SUMIF((H6:H494),">01/01/2017"and"<10/31/17,I6:I494) is not working for me.
Trying to use sumif date range for all sales numbers within a date range of one month. Thank you
Solved by G. D. in 14 mins
I need to combine an excel array lookup in a table array with multiple logical testing
Solved by V. F. in 30 mins
got an error in this formula
=IF(D18<5,((MROUND(D18,0.5)/0.5)*30)),IF(D18>5,((MROUND(D18,1)-5)*9)+80),IF(D18>12,((MROUND(D18,1)-12)*2.5)+200)
Solved by A. S. in 26 mins
Hi, I want help in hyperlink.
Like I have a 50 pdf files in a folder with a serial number starting from 1 to 50 and same serial number I have in a excel. Is it possible that directly those pdf files be as a hyperlink in that excel file against the respective serial number.
Thanks