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

Example --- I have a a Cell Y13 with the following formula in it. =IF(V13="","",W13-X13) which works well (stating - if V13 is blank leave blank, if not then subtrack w13 from x13 and enter that instead) however, I want to include another cell AN13 - I need the formula to look at AN13 first and if there is a value in AN13 put the word "Completed" if not then follow the first formula.
I would also like to create a Status column that would compute On Track or Past Due depending on what the last step is showing. - Example line 16 Step 1 shows on track but step two is past due so the status would be past due. However if the first step showed "past due" and the second step showed On track the status would show "on track". I would like to have it look at the last step entered for all 7 steps Z-AL to compute the correct status

Solved by O. J. in 15 mins

i have a column filled with a lot of text i need to break it and bring certain sentence on another column

Solved by G. H. in 29 mins

Hi there,
I'd like to be able to paste the values from one column in a worksheet to a set group of cell in another. In this instance, I have a column of 27 cells in sheet 1, and I'd like to paste one cell every 27th row in teh data tab. So, the value in Sheet1 - A1 would paste to Data tab - E3, Sheet1 - A2 would paste to Data -E29 etc.

Solved by O. Q. in 17 mins

need macro in D column to spell word in Column 2 backwards so 4th column will have the words in column 2 spelled backwards

Solved by M. H. in 18 mins

I'm trying to fill data from once tab in a workbook to another. I would like to be able to drag to the right and have the ROW number increase incrementally but keep the column the same.

Solved by F. S. in 17 mins

Column BP7 needs to find the minimum value between cells G7:L7. Between G7 & L7 is two results, I have "39" in K7 and "56.39" in L7. Clearly, K7 is the minimum value and should be the result from my formula in BP7, however it is "56.39" that is being displayed! When I force the formula to only read cell K7, it returns the result as 0.00. Please help, I cannot figure this out!

Solved by F. D. in 16 mins

I would like to be able to lock in a date/time stamp in excel. when I enter a name in the
'completed by" column, I would like the date/time to appear and lock so it cannot be changed. Please see tab SOD Tasklist 2 to work on. I read that a VBA script can be copied and pasted. I tried it but go errors. Also it requires the sheet to be protected but I cannot have it protected. Can this be done?
Thanks

Solved by B. B. in 28 mins

I need if column B paye sum( D+E+F+G = H

Solved by I. B. in 24 mins

Need VLOOKUP HELP. Trying to match the values in column A to a table range (AB:AD) . when the account number is found in the range, I want it to return the value in AD.

Solved by M. C. in 13 mins

I would like help linking a certain column or individual wording to a numerical value

Solved by E. U. in 12 mins