엑셀 2024 함수 마스터, 특별 챌린지 1일차

=UNIQUE(B10:B19&C10:C19)



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

=SORT(UNIQUE(B10:B21))



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



=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(1000)

="No."&SEQUENCE(COUNTA(E10:E22))

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



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



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



 

=TOCOL(B10:C13,1)

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

 



=WRAPROWS(B10:B17,2)

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



 

=IMAGE(C10)

=STOCKINFO(F11)