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 Tendenze
- 1. #911onABC 8,242 posts
- 2. GTA 6 17.4K posts
- 3. Broncos 24.3K posts
- 4. Raiders 36.1K posts
- 5. eddie 33.9K posts
- 6. GTA VI 26.1K posts
- 7. Rockstar 60.4K posts
- 8. #WickedOneWonderfulNight N/A
- 9. Antonio Brown 8,249 posts
- 10. #TNFonPrime 2,103 posts
- 11. UTSA 1,540 posts
- 12. Cynthia 29.8K posts
- 13. Tyler Lockett N/A
- 14. Sidney Crosby 1,618 posts
- 15. AJ Cole N/A
- 16. Ozempic 24.2K posts
- 17. #RaiderNation 1,926 posts
- 18. #ShootingStar N/A
- 19. Nancy Pelosi 147K posts
- 20. Buck 17.8K posts
Loading...
Something went wrong.
Something went wrong.