Results 1 to 5 of 5

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

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    48

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1