How do I sort numbers in a table (ie. rows & columns)?

Posted to microsoft.public.excel.misc

Twinkle17

Posts: n/a

How do I sort numbers in a table (ie. rows & columns)?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I sort in groups of 3 rows?	Blue	Excel Worksheet Functions	1	November 15th 05 10:11 PM
need help righting script to sort rows alphabetically then seperate them to line up	[email protected]	Excel Worksheet Functions	0	November 15th 05 01:23 AM
pivot table error (25000 rows!!)	Craig_Richards	Excel Discussion (Misc queries)	1	November 13th 05 06:52 PM
Transpose rows to columns w/varying numbers of lines per record	MG	Excel Worksheet Functions	8	November 11th 05 01:01 AM
Sort multiple rows by data in certain columns	lbabli	Excel Discussion (Misc queries)	1	October 28th 05 10:48 PM

All times are GMT +1. The time now is 01:21 AM.

Menu

About Us