Sorting is any process of arranging items according to a certain sequence or into different sets.

learn more… | top users | synonyms (1)

0
votes
1answer
82 views

Correct sorting after text to columns in EXCEL

I have some data in which one column represents the Days of Operations, as below: ------- Days ------- 15 7 1234567 etc. I want to "break" the column (via text to columns option in the Data tab of ...
2
votes
1answer
283 views

Vim - sort blocks of code within blocks

Note: Can someone with 300 reputation please add the tag, "scss" to this question? I'd be very appreciative. My code (scss): .cinderblock { @include minwidth(); ...
0
votes
1answer
1k views

How can I sort a list of numbers, by its last 3 digits in Excel

I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...). Each one of the nubers if have 8-9 digits and I would like to sort this column by its ...
-4
votes
4answers
3k views

Finding values that only appear once in column

I have 4 columns and ~10K rows. I wonder whether it is possible to extract the rows where the value in column (A in my case) occurs only once. I don't want to filter out the duplicates, just the ...
0
votes
2answers
692 views

Why do I get an #REF! error after sorting?

In my workbook I use this formula: =INDEX('G:\Manufacturing\WH\EXPORTS\Scanning_Reports [ScanningReport.xls]Sheet1'!$D$1:$D$65536;AB3) It works fine but when i try to sort the data i got a #ref! ...
1
vote
1answer
458 views

How to sort folders by last characters of folder name in Windows 7?

I have a stack of client folders with names like this: eastcoal 008 mee 022 orr 047 owaka 032 owen 025 powernet006 redpath 031 Normally this works, but sometimes I'd like to sort by the number. ...
1
vote
1answer
266 views

Office 2007: How to sort an Excel Table from within a Word macro

I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines: Dim Oxl_Sheet As Object Set Oxl_Sheet = ...
0
votes
1answer
879 views

UNIX command to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4

Need help with the UNIX command below to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4. (words are separated by white spaces) sort -t -k3 -k1 ...
1
vote
2answers
314 views

How can rearrange my columns to rows in Excel?

It is a bit complicated to describe in words, but I am making a literature review and I need to map how often certain theories are used within certain themes or topics. I currently have a table like ...
4
votes
2answers
2k views

How to sort Windows 7 taskbar thumbnail previews?

Here is a screenshot of the list of windows I have stacked in my Windows 7 taskbar. This is just for Explorer, but similarly I have lots of stacked windows of other processes as well. Currently ...
-1
votes
1answer
729 views

(Some Program that lets me) Manually Sort Folders in Windows 7

I want to have some convenient way of remembering the order I put certain folders in, without being forced to rename them. Some of these folders may get deleted and new folders also get added, so ...
1
vote
1answer
202 views

Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature. These cells are colored differently, but the height doesn't stick with the ...
1
vote
1answer
444 views

How to view all my Google Chrome bookmarks, sorted by date?

I want to see a flat list of all my bookmarks in Google Chrome, sorted from the oldest one to the newest one. How can I achieve this ?
3
votes
2answers
288 views

how can I sort duplicate values in excel without repeated it sequence

i want the excel sort the values A to Z first then take the duplicate values to sort it again below A to Z like the following: if i have the values a,c,b,e,d,a,c when i sort it a to z it's look like ...
1
vote
2answers
88 views

sort numbers in excel10

this is a sample of my movie list as you can see 61 is at the top and 8mm at the bottom please explain how i can have 1 at the top and 3000 at bottom 61 .45 2006 dvd 10 1979 dvd 10 items or less 2006 ...
2
votes
1answer
242 views

How to output a partial or a number from a mataching in grep or ack

I have a text file demo.txt like below. This is a line with id (9) This (8) is another line with id (10) This is a line with id too 11 This line does nothing The file has some lines with id ...
1
vote
2answers
5k views

How to sort audiobook on iTunes?

I have a question that might seem dumb, but I didn't find anything on Google. How can I do to sort my audiobook tracks on iTunes? I have books with 4 or 5 CDs and I'd like them to appear as one. I ...
1
vote
1answer
1k views

Sorting by Date Modified in Windows 8

In prior versions of Windows I used to be able to sort my folders by date modified. If any files in those folders where added, removed, changed etc... the folder date would be updated. However, in ...
0
votes
1answer
153 views

Sort files based on their meta-data

At a local storage (ext3/ext4) I have thousands of files of various types. I need to sort them, however I can come up with the criteria to do so as long as it's possible to get an overview again. I ...
1
vote
1answer
199 views

Sort columns next to last column in Linux

I have multiple files: File 1 a 1 2 b 3 2 File 2 a 2 2 3 b 4 3 3 File 3 d 3 1 2 4 e 4 1 1 2 I'd like to sort the files according to the column next to the last column, after sort: File 1 ...
0
votes
2answers
89 views

How to add another sort tab for files in Windows?

I am working with a directory of PDFs which have been scanned from actual documents in a file cabnet. When viewing a folder's contents in windows by clicking the tabs above the information users are ...
0
votes
1answer
393 views

sort du -sh by size in human readable

with the command du -sh * I get the summary of files in MB,GB, etc. If I use du -s * | sort -nk1 I get the summary sort by size. How I can get the summary sort by size in MB, GB, etc? Edit the ...
5
votes
1answer
135 views

Merge sorted lists

I have a few .txt files (in the same directory) that look like this: 123 carrot 50 apple 13 tomato 5 potato 2 pear and 100 carrot 10 apple 3 tomato 2 potato ...
2
votes
1answer
52 views

Sorting a list of files

Maybe am missing something but how do i sort in a descending order a list with this naming B7 B40 B41 B42 B8 B43 B20 B45 B53 B47 B48 B5 B6 sort -n does not sort the way i would like B5 B6 B7 and ...
0
votes
2answers
198 views

How do I sort command-line output?

I'm trying to use du to sort the output by filesize, but it doesn't looks like there's an option for that. Can I pipe it into another command to handle the sorting?
0
votes
5answers
14k views

My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...
2
votes
1answer
107 views

Tagging or defining automatically in an Excel or Libre office spreadsheet?

I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
3
votes
1answer
79 views

Bug in sort or misunderstanding

Suppose I have this file b 10 foo a 10 bar a 2 bar I want to sort by the third colum, alphabetically. In case of ties, I want to sort by the second column, numerically. In the man page for the unix ...
2
votes
1answer
164 views

How to setup DLNA sorting

What is the best way using a windows server (as the source) to provide an easy to access listing of available videos for use by DLNA enabled television sets (specifically Samsung)? I've created ...
1
vote
1answer
274 views

Command-line sort and copy text files to one single file renders an error

I stumbled on question 217394 which explains how to copy files sorted alphabetically into one single file. Trying to implement the command myself rendered the following error message: The system ...
0
votes
2answers
791 views

Sort by bar dissapeared in Windows 7 folder explorer when viewing icons

Under Windows 7 sorting by thumbnail icon files takes longer, or a different path of clicks. I have to switch viewing files in details mode (select from the sorting bar) and then sort by date ...
2
votes
2answers
461 views

Excel mass add Data to existing sheet

I have an Excel Sheet with keeps track of Persons, who have gone to certain Activities. Now i want to add an Activity with hundreds of Persons, of which some have gone to others already. Then I want ...
1
vote
2answers
317 views

Sort each standalone line alphabetically

I want to sort some items in alphabetic order, but in a very specifc way. I have, for example, the following list, each item separated by comma: monkeys, big dogs, cats pineapple, banana, orange ...
7
votes
1answer
551 views

Windows 7 Recycle Bin sort by Date Modified

In the Recycle Bin, I sorted by 'Date Modified', but the result is not in the proper order. It was neither ascending nor descending. Other sorts (by Date deleted, size, item type) all work well. Does ...
5
votes
3answers
904 views

How to do custom sorting using unix sort?

I'm using unix sort to sort a comma delimited file with multiple columns. Thus far, this has worked perfectly for sorting the data either numerically or in alphabetical order: Example file before any ...
0
votes
1answer
98 views

Don't open all mails when double-clicking at sorted group headings

At View → Sort by → Grouped By Sort you can activate the grouping of your mails by the chosen sort method. E.g. when you select the sort method "Date", you get groupings like "Today", "Yesterday", ...
4
votes
1answer
2k views

Sorting by Date - Very Slow

I'm using Windows 8 RTM. I have about 1,100 files in a folder. When I sort by date (in either direction), The address bar shows the green progress indicator as if it's working hard to perform the ...
1
vote
1answer
313 views

Tweetdeck: Sort columns by “most recent first”

This seems like a very simple question, but neither Google or the Tweetdeck manual can answer it. How can I sort columns by date in tweetdeck? My columns seems to have no order at all, mentions ...
0
votes
4answers
1k views

Reverse order using command

Is there a way i use the ps --sort option on a linux to display the processes in reverse order based on the process ID or is there another command i can use for this?
2
votes
1answer
189 views

How to sort Thunderbird by message count?

I am trying to sort the messages in my inbox by the number of messages from / to email address. After having sorted by Sort by -> From and Grouped By Sort and then displaying the Total column, I ...
5
votes
1answer
178 views

Sort By # in Windows 8

What is Sort By: # option that is available in Windows 8? A screenshot of it is given below:
0
votes
3answers
314 views

How can I sort a document according to a substring in each line on Win7?

How can I sort a text according to hashtag on Windows-7? I have a long text (.txt format) which looks something like this: Blah blah #Test 123123 #Really Blah bluh #Really klfdmngl #Test I would ...
1
vote
2answers
710 views

Change how Explorer sorts files with number in name

In Windows 7 / Windows Server 2008, if files have only number in filename, Explorer sorts them by the number. How can I change this sort to trully alphabetic, ie.: 108 1110 188 439 455 etc.
1
vote
2answers
119 views

What locale does VIM use for sorting and regular expressions?

Suppose I have a file with the following content: c C b B a A When I do :%sort, I get the following result: A B C a b c When I do :%!sort (note the '!'), I get a A b B c C I get the same ...
-1
votes
2answers
134 views

Recomposing data structure

I've a worksheet of 35k rows of the kind in the first table below that I want to reshape as in the lower table. So, I want to reshape this data in a way to get all the people within a specific ...
7
votes
4answers
4k views

Sorting numerically in a comma-delimited file with Unix

I've got a comma-separated file that looks like this: 100,00869184 6492,8361 1234,31 200,04071 I want to use sort to sort this file numerically by the first column only. Desired Result: ...
2
votes
1answer
3k views

How to order a numbered list in descending order?

When using a numbered list in Word, how can I have it order in descending order (ie. 10., 9., 8., 7., ...) ?
3
votes
2answers
861 views

Increasing productivity with huge Outlook Inbox - “Sorted Inbox” and frequencies

I am using Exchange Online and Outlook 2010 with a very high email volume and a big Inbox. I am already using colored categories and filtering of distribution lists into special folders. I am also ...
1
vote
1answer
403 views

Automatic sort for excel worksheet

I want to create a to-do list in Excel that automatically sorts the to-do entries in a list, in order of ones to do first (closest deadlines). I would also like a section that shows the tasks for ...
3
votes
0answers
547 views

Sorting mail in Thunderbird by both unread status and by date

Is there any way to make Thunderbird sort mail so that unread mail is always at the top and the e-mails are sorted by date in descending order persistently? Maybe an add-on that someone can recommend? ...