The Excel FILTER function returns a range filtered on criteria you define. It can also handle multiple AND/OR criteria.It's part of the new Dynamic Arrays.
確定! 回上一頁