Ordering random letters for a chance-random based TV gameshow.

Hello, everybody.

I will be pleased if I can get some help to solve this problem :

I have 50 cells (let's say A1 to AX1) with (3 x letter G) + (19 x letter V) + (28 x letter R) in random positions.
like in the attached file.

I would like to "read" the cells from left to right and know :

- Where is located the first V, starting from any cell ?
- Where is located the second V, starting from the same cell ?
- Is there any G between the starting cell and the second V ?
- If yes, how many ?

Example in the attached sheet :

- The first V after AA1 is AF1
- The second V after AA1 is AH1
- Yes, there are 2 G between AA1 and AH1

This (maybe) unusual inquiry is to solve a chance-random based TV gameshow under development.

Thanks a lot for the kind help.
Best.
Askalian

When the question is asked is this going to be on column header (AA1) or on the postion in row (27)?

Originally Posted by dewilk

When the question is asked is this going to be on column header (AA1) or on the postion in row (27)?

Yes, it was not really precise. It should be on the position in row 27.
Thanks.

Thanks for the great answer. It works perfectly.