+ Reply to Thread
Results 1 to 13 of 13

Random word generator for learning

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Question Random word generator for learning

    Hi Excel guro's

    In my Japanese study I encounter many new words every day, which are written into an Excel document for easier practice.

    So what I'm looking for, is a way (formula) to randomly select words from my study list, and then I have to fill in the meaning of that word - and then if possible a message will tell me if I'm correct or wrong.

    I have already tried to find the solution in other threads, and the this one come nearest my particular problem: http://www.excelforum.com/excel-gene...generator.html. However, it's way too complicated for me, and I hope you guys can help

    I used the code from the linked thread, and have added my Excel document.

    Explanation of the Excel file:

    Column A - English words
    Column B - translation of the words in Japanese, written in Japanese characters (Hiragana/Katakana)
    Column C - translation of the words in Japanese, written in Roman letters

    F7 - The formula, which randomly select a word from Column A (A1-A10), and want me to write that selected word in E7. The formula also prompt the text "Try again", if I type in a wrong word.
    NB: The problem with the text being prompted in same cell (F7), is that it replaces the show word, and I might forget what it is. So if the prompted text can't be show in another cell, then I rather not have it.

    What I would like is:
    F7 - randomly select a word from Column A (A1-A10), and want me to write the Japanese meaning of the word from column B (or C if the characters pose a problem).
    But then instead of prompting the text "Try again" (if I type in a wrong word) in the same cell, I would like the text prompted in G7... But this might be too much to ask?

    Example:
    F7 - shows the word "dog"/A5
    E7 - I type "みず"/B7 (or "mizu" if Japanese characters don't work with the formula), which is wrong
    G7 - prompts the text "Try again"

    F7 - still show the word "dog"/A5
    E7 - I type "えぬ"/B5, which is correct
    G7 - prompts the text "Correct"

    and the process starts over...

    It might be a lot to ask, but I hope you guys can help

    Edit: I have many sheets with ex. Nouns, Verbs and so on in my "Study-Excel", and it would be awesome if I could use this function in it's own sheet, linking to the others. It that possible?

    Knud
    Attached Files Attached Files
    Last edited by randomcow; 01-29-2013 at 08:08 AM. Reason: added extra question

  2. #2
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Random word generator for learning

    try this....
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Random word generator for learning

    Thanks for the quick answer abubaniyan, but can't get it to work

    I followed the step 1-4, but how do I "open" a cell?

    Knud

  4. #4
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Random word generator for learning

    Also, doesn't it create a problem when you include both column B and C in the formula?

  5. #5
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Random word generator for learning

    press the f2 button on the top of your keyboard and press enter...

  6. #6
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Random word generator for learning

    no it does.nt create any problem

  7. #7
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Random word generator for learning

    Nice!

    However...

    1. Can the "press F2 + Enter" be more easy, like just enter the text in E7? :P

    2. Can I use the formula on ex. sheet 2 with reference to sheet 1?

    3. Is it possible to use Japanese characters in E7 or only Romanji characters?
    Last edited by randomcow; 01-29-2013 at 07:18 AM.

  8. #8
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Random word generator for learning

    1. i have tried the same but its not working....
    2. yes u can use the formula on other sheets and link the same with this sheet.
    3. i havent tried the same....but you can use both

    reagrds
    abdul

  9. #9
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Random word generator for learning

    1. okey
    2. what should I change in the formula, if I have my list on sheet 2 but want the formula on sheet 1?
    3. tried typing in Japanese but it doesn't work, it's okey though

  10. #10
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Random word generator for learning

    see the sheet two....enter the value in the coloured cell..
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Random word generator for learning

    Works like a charm!

    Can't wait to try it out on my notes!

    Thanks mate

  12. #12
    Registered User
    Join Date
    01-23-2013
    Location
    Kyoto, Japan
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Random word generator for learning

    one more thing.

    What if I want the formula to start from A3 and down?
    Last edited by randomcow; 01-29-2013 at 09:08 AM.

  13. #13
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Random word generator for learning

    Replace the a1 with a3 in the formula....and change the sheet name in formula ....
    =INDEX(Sheet1!A3:A10,RANDBETWEEN(1,10))
    Last edited by abubaniyan; 02-01-2013 at 07:46 AM. Reason: forget to mention something
    Regards,
    abdul

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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