Sign in to submit new ideas and vote
Get Started

Collect function feature add multiple columns

When using the Collect function inside the Index function a user must select a range of only 1 column or the error #INCORRECT ARGUEMENT SET is returned. This also means that the row_index of the Index function must also always be 1 as the Collect function is limited to return a single value (as opposed to an array of multiple rows or columns).

I propose that Collect be changed to allow it to pass a reference of multiple columns into Index as an array of either rows (more intuitive) or columns which can be selected by the user as the row_index or column_index of the Index function.

5
5 votes

Idea Submitted · Last Updated