= VLOOKUP ( 찾을값, 검색범위, 열번호, [일치옵션] )

=VLOOKUP(G8,B8:E15,{2,3,4},0)

 

'= UNIQUE ( 범위, [가로방향조회], [단독발생] )

=UNIQUE(D10:D19)

=UNIQUE(B10:C19)

=UNIQUE(B10:B19&C10:C19)

 

'= SORT ( 범위, [기준열], [정렬방향], [가로방향정렬] )

=SORT(B10:D21,{1,3},{-1,-1})

=SORT(UNIQUE(B10:B21))

 

'= CHOOSECOLS ( 범위, 열번호1, [열번호2], … )

=CHOOSECOLS(B10:F16,MATCH(H9:J9,B9:F9,0))

 

'= XLOOKUP ( 찾을값, 찾을범위, 반환범위, [N/A값], [일치옵션], [검색방향] )

=XLOOKUP(H10,D10:D18,B10:C18)

=CHOOSECOLS(XLOOKUP(H14,D10:D18,B10:F18),1,4)

=XLOOKUP(L10&M10,B10:B18&C10:C18,E10:E18)

 

'= SEQUENCE ( 높이, [너비], [시작값], [단계] )

=SEQUENCE(6,7,P11-WEEKDAY(P11,1)+1)

 

'= FILTER ( 범위, 조건, [결과없음출력값] )

=SORT(UNIQUE(B8:B18))

=SORT(FILTER(B8:D18,B8:B18=I7),3,-1)

 

'= VSTACK ( 범위1, [범위2], … )

=VSTACK(표1,표2,표3)

 

'= TOCOL ( 범위, [제외옵션], [읽기방향] )

=TOCOL(B10:C13,1)

=TOCOL((G10:H11,G14:H15,G18:H19),1)

 

'= WRAPROWS ( 범위,나눌개수,[채울값] )

=WRAPROWS(B10:B17,2)

=WRAPROWS(TOCOL(G10:H87,1),7)

 

'= IMAGE ( URL주소, [대체텍스트], [크기옵션], [높이], [너비] )

="https://ssl.pstatic.net/imgfinance/chart/mobile/mini/"&F11&"_end_up_tablet.png"

=XLOOKUP(E11,H:H,I:I)

 

=FILTER(VSTACK(시작:끝!A2:E36),VSTACK(시작:끝!A2:A36)<>"")