![]() |
#1
|
|||
|
|||
![]()
Hi all,
Say I have a column as follows, 5 10 8 3 9 1 I want them to be 1 9 3 8 10 5 How do I do it aside from the stupid manual way? There must be an efficient way that can handle even hundreds of rows as long as you can select them. Remember it is not "sort by ascending or descending order". No answer is actually good enough those returned by google search. I am sure there must be an easy yet efficient way, just not easy enough for me to figure it out. Thanks! |
#2
|
||||
|
||||
![]()
Here's one easy way: use a temporary helper column.
In a spare column (the "helper" column), type in 1 for the first row, 2 for the second row and then fill it down the column. Then sort the entire data set by that column (largest to smallest), clear the helper column and then you're done. |
#3
|
|||
|
|||
![]()
That's it! Easy yet efficient! Thanks dude!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
clients | PowerPoint | 1 | 09-28-2010 08:49 PM |
![]() |
markg67 | Word | 2 | 06-07-2010 07:40 PM |
![]() |
saatfj | Excel | 2 | 04-15-2010 09:59 PM |
![]() |
weemikey | Word | 4 | 08-05-2009 11:10 AM |
![]() |
jerryjaysr | Excel | 4 | 06-29-2006 07:27 AM |