Forum Discussion
Solved
Wrong cell reference
whenever I drag the cells, the cell reference change, and it gives wrong values. It happens with all the formula I use. I am now doing a course, and I am calculating the trend value. The attached wil...
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.
suchetalahiri , Looks like Column B is entered in as an Array Formula. To repllicate it, select U2:U31, type in the TREND function and hit CONTROL+SHIFT+ENTER.
TheAntonyHi Anthony, I did control+shift+enter, but it didn't take the same cell reference. I am attaching the file for your perusal, thank you.