Excel Tips and Tricks - Concatenate the Results Matching the Search Value Into 1 Cell

💡 Formulas:

▶ Method 1. There is no need to sort the data when using this formula

TEXTJOIN(",";TRUE;SEQUENCE(COUNTA(FILTER(TITLE;ACTOR_ACTRESS=A2));1;1;1)&"-"&FILTER(TITLE;ACTOR_ACTRESS=A2))

▶ Method 2. Sorting the data is important when using this formula. You must first sort the data and then use the formula

TEXTJOIN(",";TRUE;SEQUENCE(COUNTA(INDIRECT(ADDRESS(XMATCH(A2;ACTOR_ACTRESS2;0;1)+1;2;1;1)&":"&ADDRESS(XMATCH(A2;ACTOR_ACTRESS2;0;-1)+1;2;1;1)));1;1;1)&""&INDIRECT(ADDRESS(XMATCH(A2;ACTOR_ACTRESS2;0;1)+1;2;1;1)&":"&ADDRESS(XMATCH(A2;ACTOR_ACTRESS2;0;-1)+1;2;1;1)))

------------------------------------------------------------------------------------------
Buy a Cofee ☕ for theworldofalgorithms: https://ko-fi.com/theworldofalgorithms

🥰Thank you for the donation. I am deeply grateful for your help!🥰
------------------------------------------------------------------------------------------

#excel
#msexcel
#msexceltutorial
#msexcelcourse
#vba
#vbatutorial
#excelvba
#fulltutorial
#excelvbatutorial
#microsoftexceltutorial
#tutorial
#exceltutorial
#advancedexcel
#advancedexceltraining
#tutor
#exceltutor
#exceltutoring
#exceltutoringonline
#onlineexceltutoring
#algorithm
#algorithms
#programming
#program
#script
#vbamacro
#vbamacros
#usingmacro
#veryuseful
#useful
#veryusefulmacro
#freeeducation
#freeprogramming
#freelancer
#excelfreelancer
#vbafreelancer
#freelanceservices
#exceltipsandtricks
#exceltipstricks
#exceltips
#exceltricks
#exceltrick
#excelhacks
#excelhack
#excelformula
#excelformulas
#excelformulasandfunctions
#exceltextjoinfunction
#excelsequencefunction
#excelfilterfunction
#excelconcatenatefunction
#excelcountafunction
#excelindirectfunction
#exceladdressfunction
#excelxmatchfunction
#textjoinfunction
#textjoin
#xmatch
#counta
#addressfunction
#concatenate
#veryusefulformula