Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save JinKwonJeon/e2f6599b844e9c44473b47d70c0bfe41 to your computer and use it in GitHub Desktop.
Save JinKwonJeon/e2f6599b844e9c44473b47d70c0bfe41 to your computer and use it in GitHub Desktop.
엑셀 SHEETMERGE 함수 (시트 취합)
SHEETMERGE = LAMBDA(범위,[인덱스],[정렬방향],[머리글개수],LET(표,VSTACK(범위),인덱스_,IF(인덱스=0,1,인덱스),머리글개수_,IF(머리글개수=0,1,머리글개수),기준필드,CHOOSECOLS(표,인덱스_),머리글,TAKE(표,머리글개수_),DB,FILTER(표,(기준필드<>"")*(기준필드<>CHOOSECOLS(머리글,인덱스_))),데이터,IF(정렬방향=0,DB,SORT(DB,인덱스,SIGN(정렬방향))),VSTACK(머리글,데이터)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment