Get instant online 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 am trying to make it show possible numbers that will work in kenken. what I want is to make groups of cells that never have multiple of the same number in them.
Solved by V. U. in 29 mins
I am trying to figure out how to copy and paste quickly without changing too much of the formula
Solved by K. J. in 15 mins
Hello, I need help fixing a graph on excel from data that contains missing values. I do not want these values to equal zero.
Solved by A. J. in 12 mins
Solved by S. F. in 20 mins
I'm trying to fill a cell with text, but it won't fill. I tried selecting wrap text, but this was not successful.
Solved by Z. H. in 14 mins
I need help getting one NON numerical cell variable to change when a numerical cell variable changes but with specific conditions. Issue: Cell A = original operation date Cell B= operation month Cell C= follow up due this date Cell D= days remaining till follow up due date (=cellC-TODAY()) Cell E= Timepoint i.e. 6 month, Year 1, Year 2, Year 3, etc. which is based of cell A i.e. Cell A= 2/8/13, Cell C= 9/5/18, Cell E= Year 5 because cell c is 5 years from cell A Cell F= 6 month followup due date (IF Cell A was before or on Dec. 31, 2015=cellA+90, IF Cell A was on Jan 2016 or after =cellA+300) Cell G= Year 1 follow up due date (=cellA+365+180+30) The date in Cell C calculates the value for the number in Cell D, and Cell E reflects the non numerical value (i.e 6 month, Year 1, Year 2, etc). If I change the date in Cell C, then the value (# of days left) in Cell D changes, but I need Cell E to change accordingly with conditions. For example: Cell C = 9/6/2017 Cell D = 1 (days left) Cell E= Year 7 If I change: Cell C = 9/6/2018, then Cell D= 366 (days left) but I need Cell E to change to = Year 8 WITHOUT me manually having to do it. I think I found the formula for that ="Year" & DATEDIF(cellA,cellD,"Y") AND it's different if it's a 6 month time point Because if change the entire column for Cell E to reflect the above equation, anything less than their respective date for the 1 year follow up doesn't show. It comes out as Year0. Either way, IF it is less than their 1 year follow up, I dont want exact months to show I just need it to say "6 month" automatically. I think I figured out the formula specifically for that situation =IF(AND(DATEDIF(cellA,cellD,"Y")<cellF),"6 month","") But I dont know how to combine the two conditional equations into just one. Basically if it's less than their 1 year follow up date it needs to say 6 months, if not then it needs to change every time I change the date in cell C
Solved by T. J. in 29 mins
I need a formula to help with the following: If I input a number in a cell that corresponds with a number from a range of numbers, I need it to input a number that corresponds with the range of numbers
Solved by G. J. in 30 mins
In the graph i need to show text. The reason in table need to be populated in graph box. I tried text box formula reference but not appropriate solution
Solved by E. U. in 21 mins
can i get a custom vba for a specific problem
Solved by A. J. in 20 mins
I have a series of airfoil coorfdinates. I need to reverse them so that the first will become the last, the second will become the second last, the third will become the third last and viceversa, etc.
Solved by A. J. in 11 mins