How to generate a random word from a range in a cell next to it?

Question

Spreadsheets

I decided to build a keyboard simulator for myself with frequent words based on libre calc.
The bottom line: there is a range with a set of ready-made words that often have to be typed at work. It is necessary that they click in cell A1 and next to B1 a word appears that needs to be typed blindly. I did the generation itself using VLOOKUP,



but I want something pleasant: I wrote a word in C1 (and correctly), I pressed enter and the next word for typing appears automatically in B2. How to do this?

PS: and even when I press enter, all the cells are updated for me, how to fix it?

Answer 1

In C2 :

=ЕСЛИ(ИЛИ(C1="";ISFORMULA(C1));"";ИНДЕКС($B$1:$B$19;1+ЦЕЛОЕ(СЛЧИС()*СЧЁТЗ($B$1:$B$19))))

...and spread down