Forum Discussion
Excel won't read ,, as skip this argument
Skipping the row_num argument in the Index formula where the first argument is two dimensional array means the formula will return an array i.e. more than one value.
And if you have excess to the dynamic array formulas, your formula will spill down the entire array down the rows.
Otherwise you will need to confirm this formula with Ctrl+Shift+Enter which will return the top item from the array returned by the formula. And I don't think this is what you are trying to achieve here.
Can you explain what exactly you are trying to achieve by skipping the row_num argument and what's your expected output?
Also, please always upload a sample workbook instead of an image of the data to get a quick and accurate answer so that we are not required to retype your data to replicate the issue you face.
Skipping the row_num argument in the Index formula where the first argument is two dimensional array means the formula will return an array i.e. more than one value.
And if you have excess to the dynamic array formulas, your formula will spill down the entire array down the rows.
Otherwise you will need to confirm this formula with Ctrl+Shift+Enter which will return the top item from the array returned by the formula. And I don't think this is what you are trying to achieve here.
Can you explain what exactly you are trying to achieve by skipping the row_num argument and what's your expected output?
Also, please always upload a sample workbook instead of an image of the data to get a quick and accurate answer so that we are not required to retype your data to replicate the issue you face.
You're welcome Bui_Hien_Dat! Glad it helped.