Find position of next characters in a column

Hi everyone !

I'm trying to find the position of the next characters in a column (thanks for the suggestion Richard !).
Basically I have a column with the values A A A B A B A A B for example and want to return in another column the row of the next appearance of "B", which would be something like 4 4 4 4 6 6 9 9 9 in the example.

I tried to use this formula to solve the problem : =SMALL(IF($E$1:$E$20000="Réalisé";ROW($E$1:$E$20000);"");3)
I don't know if this is the easiest way to proceed but it seems to be buggy as well. If I use the "insert function" option, the formula seems to work (http://prntscr.com/f1jixd) but when I click "OK" it shows #Value! in the cell !

If anyone has an idea on how to do this better or how to solve the #Value! problem I'd be very grateful !

Thanks in advance, Doule.

Hi,

This seems a much simplified example and may therefore not represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

However that said and subject to that caveat with your As & Bs in A1:A9 in B1 copied down enter

Formula:

Please Login or Register  to view this content.

...sorry Doule.

I completely screwed that up. I'd originally posted a response, noticed Ali's comment about the inadequate title and went into your post to change the title for you, in the process I seem to have removed your original request.

If you'd care to edit the post and add it back in I'll change the title, (or you can do that yourself - suggestion 'Find position of next character in a column').

Then I can unlock the response I gave.

The thread title was the problem. Please go back and edit the opening post in the thread - the message there did not need changing.

Thanks. Somewhat out of order but see #2