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!”
Here are some problems that our users have asked and received explanations on
Hi I need help with the graph. I have a table with actual vs budget for each facility by month. I would like to just have actuals showing with the budget showing inside the actual in the graph. Can you please help
Solved by S. Q. in 29 mins
Hi, just need a bit of help with this IF statement:
=IF(Z499="Open",[AB499-B499],[Z499])
Solved by M. W. in 29 mins
I have a file with an image to which I have attached a hyperlink. This image is on 100 spreadsheets in the same workbook. I need to change the hyperlink on all of them, is there a way I can do that without going to each one and making the change manually?
Solved by G. H. in 20 mins
Looking for help with Complex lookup / pattern matching formula and similar.
Solved by V. W. in 24 mins
I need to find values in G1 to G30(30 values) in H1 to H100(100 values). if within 100 ,the given 30 matches.
Solved by G. H. in 27 mins
Hi i need a formula that will extract the second to last folder name in a path
Solved by M. A. in 14 mins
See Sheet 1 G8 (68,333), look for the corresponding range that contains this number, in this case the number falls between E165 and F165 and then return D165
Solved by K. U. in 18 mins
see tha QAD sheet J column..ill simply explain.E coloums is a one of machine parts..those replacement date is J column..ok
Those dates coming form Replacements of the canvass sheet..that sheet maintain by separate person..manually..ok
Solved by F. D. in 22 mins
I am having an issue with creating a formula where I am able to track when a specific equipment is due for service by Hours rather than by date as some equipment is used more than others in a given time frame. Possibly where I could specify the hour interval a particular piece of equipment requires service.
Solved by V. C. in 17 mins
Hi,
I am trying to create a tracker to log numerical data that counts up in 1's every time a button is clicked.
there would be 3 rows in this table 'Email from internal', 'Email from client' and 'DP Automation'
I want to create a page that has 3 buttons to represent the above options and this to be where it starts at 0 in the table and you can click a button that says each heading and it automatically counts the next number and it puts this in to a table on the next sheet. (2 sheets in total)
I am unsure on the Macro coding i would need to use to be able to create this.
Thanks
Solved by F. F. in 11 mins