Re: $$Excel-Macros$$ count # of common strings between two cells

2015-08-11 Thread Paul Schreiner
  End If     Next C End Sub  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -

$$Excel-Macros$$ count # of common strings between two cells

2015-08-10 Thread Kathryn S
Here is what I have -- 1 A B C D E F G 2 12,13 11 9,10 12 14,16 6 A,B 3 12 11 9,10 11 18 6 A 1. I would like to find number of common string between A2 and A3, B2 and B3, etc 2. I would like to get total number of strings in each line, regardless of cell or comma 3. this is what the results