HOW TO PICK THE 10 DATA FROM LIST

[webmax]

Hi

I would like to run the quiz for that i have to pick only 5 winners out of the list below.

How to do using excel formula.

In the Below out of 12 we have to pick only 5 Token Nos.

Token No
1
2
3
4
5
6
7
8
9
10
11
12
Regards
Shahul

 

[Khalid NGO]

Hi Shahul,
I hope this is what you were looking for:

in A2:
=RANDBETWEEN(1,12)

in A3 with CSE:
=LARGE(ROW($1:$12)*NOT(COUNTIF($A$2:A2,ROW($1:$12))),RANDBETWEEN(1,(9+3-1)-ROW(A2)))

copy down to A6

visit this for further info:
http://answers.microsoft.com/en-us/...ers-that/50e58a5b-c494-4a96-88fa-61b68c9daafe

Regards,

 

[webmax]

Hi

The Formula is not working i am uploading the excel file

can u help on the same.

Regards
Shahul

 

[Khalid NGO]

Hi,
As to your layout i think this will work:
=LARGE(ROW($1:$12)*NOT(COUNTIF($B$2:B2,ROW($1:$12))),RANDBETWEEN(1,(9+3-1)-ROW(B2)))

Remember to enter with Ctrl+Shift+Enter

 

[webmax]

it is not working kindly put in the excel sheet and give.

 

[Khalid NGO]

Ok no problem see your file:
I've checked at my end, and its working fine

 

[Khalid NGO]

Try pressing Delete key for randomization, in any blank cell.

 

[NARAYANK991]

Hi ,

Just for the record , uploaded is a file which has a generic version for any start number and any end number.

Narayan

 

[Khalid NGO]

Impressive Sir