Jump to content
Forum Roportal
Sign in to follow this  
mihai369

Problema in excel

Recommended Posts

Se poate cumva daca am 32 (echipe de fotbal) scrise in excel sa se aleaga 4 din ele la intamplare? (randomizare, tragere la sorti) Cumva prin functia CHOOSE? Raspundeti-mi cat mai repede posibil.

Share this post


Link to post
Share on other sites

cred ca poti utiliza urmatoarea formula ( de patru ori) pentru a obtine cele patru alegeri aleatoare:

=CHOOSE(INT(RAND()*32);A1;A2;A3;...;A30;A31;A32)

EVIDENT TREBUIESC REMEDIATE EVENTUALELE ALEGERI ERONATE :

- cand RAND() = 0

- cand apare o aceeasi alegere de doua ori :(

 

Este posibil si .. relativ simplu ,

Succes

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×