T,

My Excel add-in Special Sort can sort the data in a table - either across
the rows or down the columns and in ascending or descending order.
It has over 20 different sort methods not readily available in Excel.

They include sorting by numbers only, color
prefix, middle, suffix, random, reverse, no articles,
dates, decimal (ip and dewey), length and others.
Looks and works somewhat like the regular Excel sort utility.
It comes with a Word.doc install/use file.

It is - free - just email me and ask for it. (release 1.51)
Remove XXX from my email address.
'-----
Also, I have Excel VBA code that will enter non-duplicated
random numbers in a table arrangement.
I can post that if you are interested.

Jim Cone
San Francisco, USA
XX



"Twinkle17"
wrote in message
...
I have drawn up a table 10 columns by 30 rows and have a inserted a random
number between 1000 - 3000 in each cell using the RANDBETWEEN function.
Is there a way I can sort the table so that the lowest value appears in the
top left cell and the highest in the bottom right (ie. in order by rows and
then by columns)?
I hope this makes sense.
Alternatively how can I ensure that I do not have any duplicate numbers in
my selection?
Your assistance is appreciated.
Thank you