Here’s my version.
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)))
Excellent and compact! I didn’t think of the VSTACK x TOCOL combo. Thanks for sharing
United States 趋势
- 1. Steelers 74.8K posts
- 2. Packers 55.2K posts
- 3. Tucker Kraft 12.7K posts
- 4. Tomlin 9,371 posts
- 5. Austin Reaves 17.1K posts
- 6. Jordan Love 10.9K posts
- 7. #GoPackGo 9,507 posts
- 8. Aaron Rodgers 17.8K posts
- 9. #HereWeGo 7,171 posts
- 10. Nixon 13.7K posts
- 11. Teryl Austin 1,740 posts
- 12. McManus 3,637 posts
- 13. Brian Kelly 56K posts
- 14. #WelcomeToDerry 2,405 posts
- 15. Green Bay 9,868 posts
- 16. #RHOP 8,299 posts
- 17. #BaddiesAfricaReunion 5,083 posts
- 18. Boswell 3,146 posts
- 19. Zeus 17.5K posts
- 20. Josh Jacobs 2,019 posts
Loading...
Something went wrong.
Something went wrong.