Arrays can only contain numbers, strings, errors, Booleans, or linked data types. Range references aren't supported. In this example, =OFFSET(A1,0,0,{2,3}) will cause an error.
To resolve the error, remove the range reference. In this case, =OFFSET(A1,0,0,2,3) would calculate correctly.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in the Answers community.
No comments:
Post a Comment