| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Shuffle the data at ROW level.
Hi All
This is anil. can any please answer that how to shuffle the data at ROW level. Pls let me know if there is any feasibility to shuffle the data in excel. -- Thanx & Regards Anil Reddy, India, +919247108156. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Shuffle the data at ROW level.
Add a column next to your data of random numbers with "=rand()". Then
sort by this column. On 12 Mar, 13:11, Anil Reddy wrote: Hi All This is anil. can any please answer that how to shuffle the data at ROW level. Pls let me know if there is any feasibility to shuffle the data in excel. -- Thanx & Regards Anil Reddy, India, +919247108156. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Shuffle the data at ROW level.
Hi Lori
Thanx for responding to my query. As per ur logic i done this earlier only. This will work out but the random number will not generate the unique numbers some times it will generate duplication of numbers. Due to this the shuffleing may not happen properly. Is there any other aletrnative way to do. -- Thanx & Regards Anil Reddy, India, +919247108156. "Lori" wrote: Add a column next to your data of random numbers with "=rand()". Then sort by this column. On 12 Mar, 13:11, Anil Reddy wrote: Hi All This is anil. can any please answer that how to shuffle the data at ROW level. Pls let me know if there is any feasibility to shuffle the data in excel. -- Thanx & Regards Anil Reddy, India, +919247108156. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to eport health level 7 data to excel | New Users to Excel | |||
| how do i shuffle the numbers in a table? | Excel Discussion (Misc queries) | |||
| Multi - Level Question involving Data Mapping and Formulation | Excel Worksheet Functions | |||
| Multi-level Subtotals with Excel 5.0 data | Excel Worksheet Functions | |||
| Formula for random shuffle between a range (example) b4,b78 | Excel Worksheet Functions | |||
Hybrid Mode
