Forum Discussion
Wrong cell reference
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.
In Column D, the Array Formula =TREND(B2:B31,C2:C31) is not entered in cell D2 and then copied down.
Instead, the range D2:D31 is selected first and then placed this formula in D2 and then confirm it with Ctrl+Shift+Enter. That way the whole range D2:D31 contains the same formula and D2:D31 is considered as an Array Range and as a result you cannot delete an individual cell formula from the range D2:D31, try that yourself deleting any cell in the range D2:D31 and you will get an error message which says "You can't change part of an Array i.e. it is not a single cell Array formula but a multicells Array formula which means the same formula is placed in multiple cells at once."
And you have to do the same to replicate the formula of column D in column T i.e. select the range T2:T31, press F2 key so that activecell T2 will go into edit mode, paste the formula =TREND(B2:B31,C2:C31) in T2 and then confirm it with the help of Ctrl+Shift+Enter.
To know more about the Array Formula, you may go through this https://kb.nmsu.edu/page.php?id=75305.
View the short video demo to know how to place this formula in column T.
Subodh_Tiwari_sktneer thank you sir, it worked for me.
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.