이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
CHOOSECOLS(array, col_num1, [col_num2], ...)The CHOOSECOLS function extracts one or more columns from a given array or range. You can specify columns by their index numbers, and the function will return them in the order provided.
=CHOOSECOLS(A1:C3, 1, 3)결과: Returns columns 1 and 3 from the range A1:C3.
Extracts the first and third columns from the specified 3-column range.
Yes, negative numbers count from the end of the array (e.g., -1 is the last column).