엑셀 쿼리로 검색기 만들기 질문

함수가 복잡해보이지만 색 칠해 둔 부분을 보시면 될듯 합니다

=IFERROR(QUERY('재적'!A2:V500, "SELECT A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U WHERE " &
IF(OR(ISBLANK(B1), B1=""), "TRUE",
IF(A1="전체", JOIN(" OR ", ARRAYFORMULA("A CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("B CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("C CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("D CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("E CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("F CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("G CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("H CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("I CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("J CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("K CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("L CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("M CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("N CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("O CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("P CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("Q CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("R CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("S CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("T CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")) & " OR " &
JOIN(" OR ", ARRAYFORMULA("U CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="ID",
  JOIN(" OR ", ARRAYFORMULA("A CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="연차",
  JOIN(" OR ", ARRAYFORMULA("B CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="이름",
  JOIN(" OR ", ARRAYFORMULA("C CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="연락처",
  JOIN(" OR ", ARRAYFORMULA("D CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="생일",
  JOIN(" OR ", ARRAYFORMULA("E CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="월",
  JOIN(" OR ", ARRAYFORMULA("F CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="구분",
  JOIN(" OR ", ARRAYFORMULA("G CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="반",
  JOIN(" OR ", ARRAYFORMULA("H CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="학년",
  JOIN(" OR ", ARRAYFORMULA("I CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="점수",
  JOIN(" OR ", ARRAYFORMULA("J CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="신규여부",
  JOIN(" OR ", ARRAYFORMULA("K CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="성별",
  JOIN(" OR ", ARRAYFORMULA("L CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="거주지",
  JOIN(" OR ", ARRAYFORMULA("M CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="근무지",
  JOIN(" OR ", ARRAYFORMULA("N CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'")),
IF(A1="조",
  JOIN(" OR ", ARRAYFORMULA("O CONTAINS '" & TRIM(SPLIT(B1, ",")) & "' OR P CONTAINS '" & TRIM(SPLIT(B1, ",")) & "' OR Q CONTAINS '" & TRIM(SPLIT(B1, ",")) & "' OR R CONTAINS '" & TRIM(SPLIT(B1, ",")) & "' OR S CONTAINS '" & TRIM(SPLIT(B1, ",")) & "' OR T CONTAINS '" & TRIM(SPLIT(B1, ",")) & "'"), "FALSE") ) )), "FALSE"))))))))))))))))

A1셀에 검색조건을 넣고, B1셀에서 검색할 값을 넣는 함수로 검색기를 만들었는데요

B1셀에 아무 값도 안들어가 있으면 (예를 들어 delete키를 누른다던지) 전체 값이 검색되도록 하고 싶은데 그렇게는 안되고

스페이스를 한개 이상 넣어야지만 전체값이 검색되네요 아무 값도 없어도 전체 값이 나오도록 할 수 있을까요?