Tiếng Việt
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 thg 10

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 thg 10

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 thg 10

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

0
0
1
0
31
FTMO_com's profile picture. 📈Established in 2015, FTMO developed a 2-step evaluation course to find trading talents. Get your own FTMO Account of up to $200,000!📉
FTMO.com
@FTMO_com
8 giờ

Start your journey in simulated trading with FTMO, backed by 10 years of experience.

2
0
1
0
33K
United States Xu hướng

Something went wrong.


Something went wrong.