Get instant live 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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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
Solved by V. H. in 23 mins
Solved by D. L. in 16 mins