Hi Folks,
I'm scratching my head trying to figure out how to count duplicates among concatenated characters within a single cell.
An example would be:
I got pretty close with the solution here: http://www.excelforum.com/excel-gene...in-a-cell.htmlPlease Login or Register to view this content.
This however indexes all of A and counts the duplicates amongst the entire array instead of returning individual results for each neighboring row.Please Login or Register to view this content.
I need a formula that will translate well to Google Spreadsheets as well.
Any ideas??
Bookmarks