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 Trends
- 1. Austin Reaves 42.8K posts
- 2. Steelers 84.6K posts
- 3. Packers 66.3K posts
- 4. Tomlin 12.4K posts
- 5. Tucker Kraft 15.4K posts
- 6. Jordan Love 16.6K posts
- 7. #GoPackGo 10.7K posts
- 8. Derry 19.6K posts
- 9. #LakeShow 3,730 posts
- 10. #BaddiesAfricaReunion 9,320 posts
- 11. Pretty P 3,975 posts
- 12. Zayne 20.1K posts
- 13. #LaGranjaVIP 70.4K posts
- 14. Dolly 12.6K posts
- 15. Aaron Rodgers 19.8K posts
- 16. #breachlan2 2,689 posts
- 17. Teryl Austin 2,164 posts
- 18. Sabonis 2,470 posts
- 19. yixing 8,755 posts
- 20. yeonjun 51.7K posts
Loading...
Something went wrong.
Something went wrong.