Feb 15 2021 09:58 AM
As it is being shown on the picture attached to this post, my Excel is "replying" and "applying" automatically a formula that has been written on the G4 cell all the way through the G6 one and this behaviour is being alerted by the blue line around those cells. How do I deactivate this feature, pelase?
Feb 15 2021 11:00 AM
SolutionThat is called spill. In English your formula is
=OFFSET(dados!$c$3,1,,COUNTA(dados!c:c)-1)
it returns as many records starting from next to C3 as counted in column C minus 1.
Not sure what you'd like to return, if only one next record then =OFFSET(dados!$c$3,1,,)
Feb 15 2021 12:04 PM
<How do I deactivate this feature, please?>
By reverting to obsolete versions of the Excel and applying traditional spreadsheet techniques.
Better, would be to learn and embrace the new functionality. It is well worth the effort!
Feb 15 2021 01:14 PM
Thank you for answering me! I made the suggested changes on the formula and it worked out!
Feb 15 2021 11:00 AM
SolutionThat is called spill. In English your formula is
=OFFSET(dados!$c$3,1,,COUNTA(dados!c:c)-1)
it returns as many records starting from next to C3 as counted in column C minus 1.
Not sure what you'd like to return, if only one next record then =OFFSET(dados!$c$3,1,,)