Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random Numbers between 0 and 31 in Excel 3

Status
Not open for further replies.

qwasy

Technical User
Nov 28, 2006
7
SI
hi guys - especially Zathras :)

(look at thread56-1281655 - 22 Sep 06)

I need to fill a column with random the numbers 0-31.

maestro Zathras wrote nice and short:
A1: =MID(W1,INT(RAND()*(11-ROW(W1)))+1,1)+0
W1: '0123456789
W2: =LEFT(W1,FIND(A1,W1)-1)&MID(W1,FIND(A1,W1)+1,99)

i tried to modify this solution (W1) for numbers 01 02 03 04 ..... 29 30 31 (days of month) - unsuccessfully

would you be or anybody so kind and help me ?

thanking you in advance
 
SkipVought - how can i assign you another star ?

perfect solution :-D
[thumbsup2]
[thumbsup2]
 



Thanx for the thot!

Skip,
[sub]
[glasses] When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![tongue][/sub]
 
qwasy - you can't, but I agree with you so I will on your behalf.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top