“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

I NEED A FORMULA THAT I USE TYPE BY A FOLDER

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