Hi guys,
This problem sounds really trivial and, thus, I tried to workaround by using excel len, search and count formulas. But since excel can't search for strings longer than 253 characters, I could not get what I am trying for.
So the problem is:
I have a workbook with two sheets- "Problem" and "Solution". In the former sheet, there are two columns- one containing IDs and other containing strings. Many of the strings in the column are >253 characters long. I want to compare string of each cell against the whole strings column and if it matches, I want the IDs of the matching strings to be pasted in "Solution" sheet. For Illustration purpose, I am showing the problem and desired solution hereunder:
Waiting for some assistance !
Problem Sheet:
Sets Strings
Set1 ABCDEFGHIJKLMNOP
Set2 CDEFGHIJKL
Set3 ABCDEFGH
Set4 ABCDEFGHIJKL
Set5 ABCDFGHIJ
Set6 JKLMNOP
Set7 POHIJABCDEF
Set8 HIJABCDE
Set9 DMNCDEFGHIJKL
Set10 RORJKLMNOPSTMNP
Solution Sheet:
Sets Match
Set1 Set1
Set2 Set1, Set2, Set4, Set9
Set3 Set1, Set3, Set4
Set4 Set1, Set4
Set5 Set5
Set6 Set1, Set6, Set10
Set7 Set7
Set8 Set7, Set8
Set9 Set9
Set10 Set10
Bookmarks