can someone help me speed up the process in excel. I need formula to find links that contain the same number and merge them all into the same cell. So far I've done it with the formula but it's a slow process for me when I have over 1000 links: =TEXTJOIN( ", ";TRUE;B110:B114)
Thanks!
I would use several columns. Col B, extract the number from the strings with
=mid(A2,26,4)
Column C formula
=If(B2=B1, "", D2)
Column D
=IF(B2=B3, A2 & "," & D3, A2)
Copy those all the way down and answers with be in C. Filter out the blanks if you want.