Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 strings which contain multiple numeric values like
String 1: 123, 456, 789
String 2: 234, 567, 456, 231, 123
Is there anyway I can return the common values between 2 strings i.e. 123 and 456 ?
If you have four rows like?
String 1: 123, 456, 789
String 2: 234, 567, 456, 231, 123
String 3: 1234, 4567, 789
String 4: 2345, 567, 4567, 231, 123
Actually these string are dynamically generated based on user selections. I need the intersection to be computed and stored in a variable. I was thinking of doing same with an variable starting with = If I go the macro way, probably I would need an action to invoke the macro on each user selection ?