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

I’m trying to find excel formula that calculate the values for slope, intercept, and r^2 for a log regression (the values from the log regression formula in the chart view).

Solved by O. J. in 29 mins

In the "base sheet" tab of this workbook, I've entered information in a list for 66 different product types. The following sheets need to take the information from this base sheet. For example, sheet "1" should be importing the information entered into line 1 of the "base sheet", sheet "2" should be importing information entered into line 2 of the "base sheet", and so forth. After page 41 the information in each sheet does not match the information provided in that line of the base sheet. I need the formulas corrected so that all of the successive pages import the information from the correct corresponding lines on the base sheet.

Solved by X. S. in 19 mins

I have a sheet that is used as a log. So change order 1, 2, 3 etc. The individual sheets for each change order has data that i want to link in the log. I am trying to figure out how to link the data in a cell in the log such as "description" and have it correspond with the same description on the change order sheet. I can do this where there is only one sheet to link to but when the change order for the log changes from 1 to 2 how does it know to go to change order 2? I hope this makes sense. thanks.

Solved by E. F. in 13 mins

I Need Help in Pivot ... for calculate Growth % on 2 column keeping base 3rd column ...

Solved by S. E. in 13 mins

No Item Cost
1 Bag $1 Boy 1 Boy 2
2 Books $2 Bag Shoes
3 Shoes $2 Books Slippers
4 Slippers $1 Laptop Watch
5 Laptop $2 $5 $5
6 Watch $2
I want to return the values on the right where boy 1 and boy 2 can get a mixture of choices of what they can get if they spilt the items evenly (total $10/2 = $5)

Solved by A. A. in 17 mins