Random Choose Cell of a Row

**hello_hello** · 10-18-2015, 04:07 AM

Hi everyone,

Is it possible to have excel to fill in 3 randomly chosen cells from 5 cells of a row with the word "Prize" and the remaining 2 with "Try Again"?

Thanks.

**Sadath31** · 10-18-2015, 04:48 AM

Hi

First Three Cells =IF(ISEVEN(RAND()*10),"Prize","Try Again")
4th cell =IF(COUNTIF(C1:C3,"Prize")<3,"Prize","Try Again")
5th cell =IF(COUNTIF(C1:C4,"Prize")<3,"Prize","Try Again")

**hello_hello** · 10-18-2015, 04:56 AM

Originally Posted by Sadath31

Hi
First Three Cells =IF(ISEVEN(RAND()*10),"Prize","Try Again")
4th cell =IF(COUNTIF(C1:C3,"Prize")<3,"Prize","Try Again")
5th cell =IF(COUNTIF(C1:C4,"Prize")<3,"Prize","Try Again")

Thank you so much, I got the idea, instead of making all of them random, few different formulae will ensure the number of "Prize".

Random Choose Cell of a Row

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Random Choose Cell of a Row

Re: Random Choose Cell of a Row

Re: Random Choose Cell of a Row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Choose random number between given values

How to choose random sample in dataset with

Choose Random Cell From Range Value Unless Equals 0

[SOLVED] If row contains 1(s) then choose random column title

Choose 4 Random Numbers if they are not textbox1 or textbox2

Choose Random Value Based On List

how to choose random namber form loop?

Bookmarks

Bookmarks

Posting Permissions