I have an array filled with letters that occur in a particular order. The length of each row varies AND where the row starts also varies.
I need a formula that searches each row, counts each letter and where they begin, respective to each string of letters. Then organizes that information into an array.
This string of letters:
Phrase 1: A D E A A F G
Would generate this output:
Because "A" shows up in the 1st, 4th, and 5th positions in this row.
This will be repeated for around 700 rows.
Here is a copy of a sheet for your review.