place alphabet randomly in cells?

[Excript]

Is it possible to place the limited amount of same number/alphabet in a given numbers of cells?

For example I want to have 5 same alphabets to be placed randomly in 15 cells for the same row. Can it be done?

[shg]

I'm a litle clueless as to what your trying to do, but maybe in B1 and copy down,

=if(rand() < 0.3, "a", "")

[Excript]

As in in 1 column i select 20 rows/cells in that column..i would like excel to place 5 A randomly in that 20 cells. Placing of the alphabet has to be done randomly.

Is that possible?

[Steel Monkey]

Also a way in vba would be something like(in a standard module) :

Please Login or Register  to view this content.

If neither of these solutions are what you are after maybe some more clarification is needed..

Hope this helps!

[shg]

You want to place exactly 5 a's in B1:B20 starting in B1?

[Excript]

You want to place exactly 5 a's in B1:B20 starting in B1?

Yes, I want it to be placed randomly in B1 to B20 starting in B1 and only 5 A's

Can it be done?

Thanks for your help in advance

[shg]

In B1: =IF(RAND() <= 0.2, "a", "")

In B2 and copy down to B20: =IF(RAND() < (5 - COUNTIF(B$1:B1, "a") )/ (21 - ROW()), "a", "")

[Excript]

Shg Thanks for finding me that formula but I do have a question.

I noticed that the formula runs its course again when I filter the alphabets.
Is there anyway to fix it?

Like I would like to filter all the blank cells and show only the random alphabets but once i do that, it will randomly place it again.

Thanks.

[shg]

I noticed that the formula runs its course again when I filter the alphabets.
Is there anyway to fix it?

Like I would like to filter all the blank cells and show only the random alphabets but once i do that, it will randomly place it again.

I'm sorry, I don't understand any of that.

Maybe you could add the formula, copy the results, and paste over itself as values.