Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
luiza69 pe Simpatie.ro
Femeie
25 ani
Bucuresti
cauta Barbat
27 - 75 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Extract Random Cell From Range Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
Mrrrr
AdMiN

Inregistrat: acum 17 ani
Postari: 2228
I have a list of games on Steam but I'm playing just 1 or 2 of them, and I wanna play more / all.

The following formula will extract in cell B1 one random value from column A.

=INDEX($A:$A;RANDBETWEEN(1;COUNTA($A:$A));1)

Made an excel file containing my game list in column A and the formula above in cell B1, then added it to startup. So whenever the PC starts, the file opens showing a random game to play in cell B1. That's the game I play that day. I move its name from column A to C, so the next extraction occurs from the remaining games. Do this every day until I'm done with the list, then I move all games back to column A.

Source:


_______________________________________


pus acum 2 ani
   
Pagini: 1  

Mergi la