Get instant chat 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
Hello, I need help create a chart that shows the seasonality of purchase activity from 9 consumers. What I need is the total purchase of any drink for each qtr of each year, the purchase levels of individual drinks for each qtr and the overall spendeture and purchase of each account
Solved by X. U. in 23 mins
I have two columns of figures, each one totalled. All I wish to do is subtract one total from the other. This should simplicity itself. However, the formula (a simple =D45-D62) cannot recognise the latter cell and gives me a false result. I just cannot understand why. Can you help?
Solved by B. W. in 19 mins
Hello,
I have an employee attendance tracker sheet which is protected by maximum nos 10, I want to be add more employees on it, like 100 or more, is there any way? it is VBA protected. I cannot upload this file because it macro enabled.
Solved by G. U. in 25 mins
Can you help me to create a function that will compute for the length of stay of each employee with this format "10 years & 6 month"
Solved by C. S. in 19 mins
I need help with a scatter plot and changing the color of different values
Solved by K. D. in 20 mins
I would like to take out the blank options in the drop down menus on my worksheets.
Solved by G. Y. in 18 mins
I have a variable called "First Order Discount", which is a yes or a no, I would like to create another variable that would compare this against my User ID variable and mark all User Ids where this first order discount variable is equal to 1 as also equal to 1.
Solved by A. E. in 26 mins
I need a formula which gives the result after multiplied between 2 cells. In addition, the amount has to be multiplied by 100 if the reference cell is filled. Example as per attached: cell K5 x L5 = M5. Cell M5 has to be multiplied with 100 if cell F5 is filled. If F5 is empty, then M5 is just equal to K5 x L5
Solved by S. U. in 18 mins
Hello, I am trying to assign a macro to a shape using the developer tab in Excel 2013. When I run the macro it opens VBA, and gives me the compile error: "Sub or Function not defined", the Macro interacts with the Solver excel tool. I remember that there is some settings that should allow interaction between macros and the Solver tool, but I do not remember how to access these settings
Solved by E. C. in 24 mins
Continuation from previous chat regarding Time Elapse issue - I was just speaking with someone who was helping me figure out the right formula to make my spreadsheet calculate time elapsed excluding weekends and holidays
Solved by F. Q. in 13 mins