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

I need help with a formula. I am wanting to get the Varians from the value in column F and the last value in column E for each account. I am having difficulty figuring out how to grab the correct value in column E.

Solved by C. Y. in 24 mins

Example:
Column E - User inputs date of test
Column H - Indicates number of days since last test (=DATEDIF(E16,I16,"yd")
Column I - Hidden Column with the current days date to give number of days since last test in column H.
What's happening in Column H is that from the value 365, the value in volumn H reverts back to 0 and restarts the count and i need it to continue.

Solved by G. Q. in 17 mins

I just had this formula completed and I just need the last values in the last column, but now I cant get excel to fill out the remaining values in column O.

Solved by O. C. in 17 mins

i have a spreed sheet with list of prices from different company's. In the header of each column have the company.The first cell of each row gives me the driver and the rest of the row gives me the company prices.The two last columns give me the value of minimum and maximum price for each row. is there a way were i can relate the value in the last two column with company in the header section? for example; the color that i gave to each company be the same in the value in the two last column.

Solved by I. C. in 22 mins

This is hard to explain, but I need help with a column array formula in an average where the first array value is a cell in a calculated row and the second array value is the last cell in the column.

Solved by A. U. in 14 mins