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?
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.