| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random row numbers
i have 2 columns and 6276 rows in my worksheet that listed alphabetically
for examle 1 anu dgs 2 bru ... 3 cho ... 6276 z.. ... my question is how can i list them randomly not alphetically |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random row numbers
In Column C, enter this formula:
=RAND() Copy this down for all 6276 rows of data Then sort all of your data using Column C. HTH, Elkar "ldzppln" wrote: i have 2 columns and 6276 rows in my worksheet that listed alphabetically for examle 1 anu dgs 2 bru ... 3 cho ... 6276 z.. ... my question is how can i list them randomly not alphetically |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random row numbers
=rand() in a helper column, and sort by that column.
-- David Biddulph "ldzppln" wrote in message ... i have 2 columns and 6276 rows in my worksheet that listed alphabetically for examle 1 anu dgs 2 bru ... 3 cho ... 6276 z.. ... my question is how can i list them randomly not alphetically |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
| I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Linear Mode
