Loading...
「ツール」は右上に移動しました。
67いいね 11040回再生

How to use FILTER function to exclude multiple criteria (FILTER, NOT, ISNUMBER and XMATCH)

How to use FILTER function to exclude multiple criteria

One of the useful dynamic array functions is FILTER function, which usually used to filter based on the criteria you want to include, the reverse way by using NOT, ISNUMBER and XMATCH function with FILTER, you can exclude a list of criteria.

コメント