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
Try to find the fun gift that is also practical in some way? 18-in-1 snowflakes multi-tool must be the one! Click to get yours now!
United States الاتجاهات
- 1. #MondayMotivation 24.5K posts
- 2. Good Monday 25.9K posts
- 3. Austin Reaves 48.9K posts
- 4. Talus Labs 17.5K posts
- 5. Steelers 86.1K posts
- 6. Category 5 15.2K posts
- 7. #BreachLAN2 3,513 posts
- 8. Tomlin 12.9K posts
- 9. Jamaica 59.7K posts
- 10. Packers 68K posts
- 11. Derry 21.5K posts
- 12. Zayne 24.5K posts
- 13. #BaddiesAfricaReunion 11K posts
- 14. Jordan Love 17.5K posts
- 15. Hurricane Melissa 37.6K posts
- 16. Pretty P 4,453 posts
- 17. yixing 14.2K posts
- 18. GameStop 50.8K posts
- 19. #GoPackGo 11K posts
- 20. Tucker Kraft 15.9K posts
Loading...
Something went wrong.
Something went wrong.