ภาษาไทย
English Indonesia Türkçe Deutsch Español Português Pусский Français Italiano Nederlands Polski العربية ไทย Tiếng Việt 繁體中文 简体中文 日本語 한국어
exceltips99's profile picture. Sharing Excel tips that make complex tasks simple — database-style tables, advanced functions like LAMBDA and spill/dynamic arrays, smoother workflows.
exceltips99
 @exceltips99
13 ต.ค.

Here’s my version.

exceltips99's tweet image. Here’s my version.
SubtleFred_'s profile picture. Arsenal, Financial Modeling, Excel & Analytics | Views are solely mine
Fred and 425 others
 @SubtleFred_
13 ต.ค.

Long time, no #excel challenge. 😀 Shared by Kotteswaran Velu on LinkedIn, here’s my formula: 👇 =MAP(A2:A5,B2:B5,LAMBDA(a,b,LET(x,TEXTSPLIT(a,","),y,TEXTSPLIT(b,","),d,HSTACK(x,y),s,HSTACK(SEQUENCE(,COUNTA(x),1,2),SEQUENCE(,COUNTA(y),2,2)),r,ARRAYTOTEXT(SORTBY(d,s,1)),r)))

SubtleFred_'s tweet image. Long time, no #excel challenge. 😀 Shared by Kotteswaran Velu on LinkedIn, here’s my formula: 👇 =MAP(A2:A5,B2:B5,LAMBDA(a,b,LET(x,TEXTSPLIT(a,","),y,TEXTSPLIT(b,","),d,HSTACK(x,y),s,HSTACK(SEQUENCE(,COUNTA(x),1,2),SEQUENCE(,COUNTA(y),2,2)),r,ARRAYTOTEXT(SORTBY(d,s,1)),r)))
3
0
9
2
612
1
0
1
0
58
SubtleFred_'s profile picture. Arsenal, Financial Modeling, Excel & Analytics | Views are solely mine
Fred and 425 others
 @SubtleFred_
13 ต.ค.

Excellent and compact! I didn’t think of the VSTACK x TOCOL combo. Thanks for sharing

0
0
1
0
31
Starlink's profile picture. Internet from space for humans on Earth. Engineered by @SpaceX
Starlink
@Starlink
10 พ.ค.

Stream, call, game, and work in even the most remote locations. Order online in minutes

239
232
3พัน
293
27.8ล้าน
United States เทรนด์

Something went wrong.


Something went wrong.