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.

For example:

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.


  • @pnuts Sorry, the Phrase 1 string had a typo, it is now fixed. I should note that each of the letters of that string is in it's own cell. – user3861339 Aug 9 '17 at 15:06
  • @pnuts correct. each phrase can use all letters, and start in different positions. I'm interested in the position of each letter relative to itself not the column – user3861339 Aug 9 '17 at 15:28
  • Correct, and I have a solution that does just that, but was curious if there was a way to avoid creating a 'helper' array – user3861339 Aug 9 '17 at 15:34
  • do you still need a solution for this? – user0 Jul 14 at 22:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.