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. #DWTS 7,089 posts
- 2. Elaine 37.4K posts
- 3. Whitney 6,479 posts
- 4. Ezra 5,971 posts
- 5. Don Lemon 7,487 posts
- 6. Dugger 3,964 posts
- 7. Caden 3,632 posts
- 8. Keion White 3,319 posts
- 9. #FrozenFrenzy N/A
- 10. Alex Sarr N/A
- 11. Carrie Ann N/A
- 12. #LightningStrikes N/A
- 13. #LumioseOOTD 1,043 posts
- 14. Luke Kwon N/A
- 15. #ShootingStar N/A
- 16. Jaime 17.6K posts
- 17. New World 93.4K posts
- 18. Embiid 8,556 posts
- 19. Tinashe N/A
- 20. Bob Costas N/A
Loading...
Something went wrong.
Something went wrong.