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:
Roxiii
 | Femeie
23 ani
Bucuresti
cauta Barbat
23 - 38 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
This can be done faster, see post #2
I want to generate letters M or F in 300 cells, but this can't simply be done with the formulas from source.
First, I made the formula from Source to show me 2 consecutive letters, so in cell D2:
=CHAR(RANDBETWEEN(76;77))
will randomly show either letters L or M
Dragged down 300 cells, then copied and pasted them as values, so rand between doesn't change the letters on every sheet calculation.
Now in E2 I wrote the following formula and dragged it down 300 rows. It will show M if M is displayed in column D, and it will show F for every L displayed in column D:
=IF(D2="M";"M";"F")
Then copied this and pasted it into column D, thus obtaining my desired random M or F.
Source:
_______________________________________
|
|
| pus acum 6 luni |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
This can be done easier by adapting the formula from here:
The formula becomes:
=CHOOSE(RANDBETWEEN(1;2);"M";"F")
_______________________________________
|
|
| pus acum 6 luni |
|