Monday, February 18, 2013

Google Spreadsheets Filter() - referencing source array in criteria

The filter() function looks through a source array, and filters it according to condition =FILTER(A:A,ISNUMBER(A:A))

My source array is a rather long formula, so i end up repeating the same formula twice in the ISNUMBER() condition

=FILTER(ARRAYFORMULA(1+(SORT(TRANSPOSE(FILTER($N9:9,ISNUMBER($N9:9),$N$3:$3="Skills [s]")),1,FALSE))*StackPenalty), ISNUMBER(ARRAYFORMULA(1+(SORT(TRANSPOSE(FILTER($N9:9,ISNUMBER($N9:9),$N$3:$3="Skills [s]")),1,FALSE))*StackPenalty)))

Is there any way i can write this shorter? Any way to reference the source array by some name? Index? Any way to use ISNUMBER() condition without passing the whole source array?

Source: http://webapps.stackexchange.com/questions/40556/google-spreadsheets-filter-referencing-source-array-in-criteria

gap Victoria Secret Bath And Body Works Dicks Sporting Good office max office max jcp

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.