본문 바로가기

IT

엑셀 filter 기능

=query(filter('원본자료'!C:G,arrayformula(weeknum('원본자료'!$C:$C,1))=weeknum($C$1)),"select Col5, Col4, Col1, Col2")