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. #AEWDynamite 18.3K posts
- 2. Will Richard 3,839 posts
- 3. #Survivor49 3,023 posts
- 4. #SistasOnBET 2,193 posts
- 5. #ChicagoPD 1,015 posts
- 6. Klay 6,443 posts
- 7. Godzilla 29.4K posts
- 8. #AmphoreusStamp 2,240 posts
- 9. Nico Harrison N/A
- 10. Unplanned 4,664 posts
- 11. Binnington 2,295 posts
- 12. Harrison Barnes N/A
- 13. Savannah 5,433 posts
- 14. Kent State 1,338 posts
- 15. Athena 10.2K posts
- 16. Cade 30.9K posts
- 17. Jovic 1,024 posts
- 18. Mitchell Robinson 1,353 posts
- 19. Pat Spencer N/A
- 20. Ovechkin 7,779 posts
Loading...
Something went wrong.
Something went wrong.