random number without repeating?
i want to do the random number for every each cell without repeat the same
number?do you know how to solve my problem? |
Say you wanted 1 to 20 to be your numbers.
In an out of the way column, say Z, enter into Z1: =RAND() And copy down to Z20. You can now enter this formula anywhere you wish, and copy down for 20 rows: =INDEX(ROW($A$1:$A$20),RANK(Z1,$Z$1:$Z$20)) If you don't want consecutive numbers, you can make your own list of numbers, or letters or even words. Just enter them in say ColumnY, from 1 to 20, and try this: =INDEX($Y$1:$Y$20),RANK(Z1,$Z$1:$Z$20)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "nonoi via OfficeKB.com" wrote in message ... i want to do the random number for every each cell without repeat the same number?do you know how to solve my problem? |
For most purposes, RAND() provides a pretty good approximation of unique
random numbers for relatively small sets. If you mean random integers, see http://www.mcgimpsey.com/excel/randint.html In article , "nonoi via OfficeKB.com" wrote: i want to do the random number for every each cell without repeat the same number?do you know how to solve my problem? |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com