이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
FILTER(array, include, [if_empty])The FILTER function allows you to extract data from a range or array based on a boolean condition. It returns a dynamic array that automatically spills into neighboring cells, updating whenever the source data changes.
=FILTER(A2:B5, B2:B5>100)결과: Filtered rows
Returns all rows from A2:B5 where the value in column B is greater than 100.
This error occurs if no items meet the criteria and you did not provide an if_empty argument.