Create 30 random Nos then rate them in order

**kawa13** · 04-18-2013, 11:26 AM

Hi again guys,

I'd like to create numbers at random from 1 to 30, say in column A, then in column C record in which order the random numbers appear. Sounds simple enough.....don't it?

As ever, your help would be greatly appreciated

Regards,

Kawa13

**kawa13** · 04-19-2013, 03:15 AM

Either no takers, or it's hard and everyone is beavering away!!!!

**jindon** · 04-19-2013, 04:57 AM

Simple but question is how do you want to "RECORD" in col.C?

If you upload a sample workbook, it will be easier to understand.

**kawa13** · 04-19-2013, 05:12 AM

Hi Jindon,

Thanks for responding.

Please find sample document attached

Domo arrigato

(excuse my spelling)

**jindon** · 04-19-2013, 05:41 AM

only one r is enough.... Arigato.

This code will rearrange the data in col.D to col.E according to the rows in Col.D

Please Login or Register  to view this content.

**JapanDave** · 04-19-2013, 05:45 AM

Try this,

Please Login or Register  to view this content.

**kalak** · 04-19-2013, 06:59 AM

randomizes whatever's in Col D into Col E

Please Login or Register  to view this content.

Create 30 random Nos then rate them in order

LinkBack

Thread Tools

Rate This Thread

Display

Create 30 random Nos then rate them in order

Re: Create 30 random Nos then rate them in order

Re: Create 30 random Nos then rate them in order

Re: Create 30 random Nos then rate them in order

Re: Create 30 random Nos then rate them in order

Re: Create 30 random Nos then rate them in order

Re: Create 30 random Nos then rate them in order

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions