Rakesh Menon
New Member
I am not sure if this has been asked before. In the attached excel sheet, I have two sets of the same numbers - one with the array (curly brackets) and one without.
The results for these two are completely different. I would like to understand what the Array action does to the formula.
I got this on a file from one of the colleagues and did not understand why the number with the array is different, when the formula on the face of it should give a different result.
The results for these two are completely different. I would like to understand what the Array action does to the formula.
I got this on a file from one of the colleagues and did not understand why the number with the array is different, when the formula on the face of it should give a different result.