我在微软excel中有这个公式,当上传到谷歌工作表时,它变成了零,并转换成了array_constrain公式。有人能帮帮我吗?下面是我使用的excel公式。EXACT($A:$A,$F4),$B:$B),2,0)),0,VLOOKUP(1,CHOOSE({1,2},--EXACT($A:$A,$F4),$B:$B),2,0)) 有没有人能帮我把这个转换成googlesheet可以
Are you looking to constrain an array result to a specific size? LearnHow to use the ARRAY_CONSTRAIN formula in Google Sheets. Editor’s note: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness....
As we have noticed, we can treat arrays as Lists but cannot constrain the data type in a list as it is done in an array. This will be understood much more in the next section. Python Built-in Array Module There are many other built-in modules in Python which you can read more about...