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

learn more… | top users | synonyms (1)

1
vote
1answer
234 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
2
votes
1answer
207 views

How to disable message sorting on Thunderbird?

I keep constantly clicking the "subject" sorting button, when I want to click on the newest message. How can I disable the sorting completely? Perhaps by hacking the .exe file? It's pretty much ...
-4
votes
1answer
1k views

how do you ignore empty cells?

I'm using this function to rank data: =SUMPRODUCT(($B$2:$B$11>B2) / COUNTIF($B$2:$B$11,$B$2:$B$11&"")) + 1 This version assigns 1 to the highest value and sequentially increasing ranks to ...
0
votes
1answer
50 views

Windows 8 sorting by name

I have a lot of documents and when I sorting them by Name, it looks like this: Story - descriptions.docx Story.docx Tale - descriptions.docx Tale - maps.jpg Tale v2.docx Tale.docx Why it is sorted ...
1
vote
1answer
402 views

On the command line, what is a “general” and “string” numeric value when sorting?

According to "man sort" there are two ways to sort numerically: -g, --general-numeric-sort compare according to general numerical value and -n, --numeric-sort compare ...
0
votes
1answer
65 views

Sorting iTunes Artist field

I'm trying to sort out my music and I have a couple of artists who have changed their name or have an album with solo tracks and some in a group. Two examples are 'the game' and 'adam and the ants' ...
2
votes
2answers
7k views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...
1
vote
0answers
337 views

Music Library Sorting Issue

I'm using WMP for for managing my music library. Lately I noticed something. I was reorganizing my library and came across a strange -I mean annoying- behavior of WMP. The way WMP sorts Artists. ...
4
votes
2answers
354 views

Linux command line / Move files filtered by lexicographic order

I have some files in a directory that are named IMG_0001.jpg ... IMG_9999.jpg. I want to move to another directory the files that lexicographically have a name greater than IMG_9431.jpg How can I do ...
6
votes
1answer
125 views

List of files under a directory in name order

I wanted a list of files under a directory in name order to pass to an image viewer. I am using find $PHOTODIR -iname "*.jpg". Unfortunately this produces the images out of order. On a USB key ...
4
votes
2answers
87 views

Sort files with grep

I have a few hundreds of output files, of which some contain error messages. Lets say I want to automatically put all files containing the string "ERROR_1" in a "subfolder_1", and the rest in a second ...
3
votes
2answers
1k views

Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X Example: A B C 1 1 X=7 2 3 3 5 4 8 ANS=5 Do you have any smart ideas for this problem?
1
vote
2answers
299 views

How can I sort and de-dupe a very long list of words?

I have a 400 megabyte file. The file is a list of words, each word on a single line. End of lines are a mix of cr/lf and lf. Some of the words are unicode. I'd prefer answers for Linux or Windows ...
2
votes
0answers
211 views

How to sort Google Drive search results by title?

I find Google Drive very convenient as an online notebook to store my diary and records, that I can access anytime, anywhere. Now when I want to search for a particular string of text, the only ...
1
vote
0answers
40 views

Reordering file lines like other file (Unix)

Is there a tool (or option for sort) which will re-order lines of a file so that they are ordered like a key in another file? For example, I have a data file: T01F01475558 30 T01F022B3A17 31 ...
-1
votes
1answer
75 views

Explorer sort order by date (not by type) [closed]

Why Explorer in Windows 7 keeps grouping files by type when I want them by date? Each group is sorted by date (modified), but I would like all files sorted by date (mixed types, like an old'n'good ...
2
votes
1answer
457 views

Sort lexicographically in bash

I want data to be sorted in the way Python sorts it, comparing ASCII values. But sort command seems too clever for that. Take a look. Since '.' < '9': $ sort . 9 ^D . 9 $ sort 1. 19 ^D 1. 19 ...
1
vote
2answers
301 views

Sort by multiple columns in Windows Explorer 8

I have a directory, which contains many files (more than a thousand), from different types (file extensions). I can sort them by Date modified, or by Type. But seems that I can't sort them by both ...
2
votes
1answer
1k views

Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
0
votes
1answer
553 views

sort tab delimited text fields involving spaces

I am having difficulty with the Unix sort command when tab delimited fields are introduced. If a file test.txt contains: Hello (2) Hello (1) Hello applying a sort: sort test.txt produces the ...
-4
votes
1answer
636 views

Find n rows in spreadsheet with lowest values in one column [closed]

There are two columns, say, A & B. Total 50 numbers are inserted in Column A; i.e., A1..A50 (numbers can be same like 20 can come more than one time or up to 50 nos.). In front of every row of A1 ...
2
votes
2answers
191 views

Why is sort.exe truncating large output on 32-bit Windows?

We have a data file from a client which is 1,443,777,659 bytes in size. Sorted output has lines missing and is only 1,269,801,985 bytes in size. Sample command: sort -k 1,10 -T . -s -i ...
13
votes
3answers
6k views

Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...
0
votes
1answer
444 views

Changing default sort order in Windows 7 desktop search

If I do a search (usually, I'm looking for an email), the results are presented in date-modified order by default I can do Sort By / More... and select Date Received, then Sort By and select Date ...
0
votes
1answer
67 views

how to delete a file after sorting in Linux

I have a huge file that needs to be sorted in Linux, for example: sort -k1,1 -k2,2n /dir/fileA.sam > /dir/fileA_sorted.sam Because I ran out of disk space, is there a way to delete the original ...
0
votes
2answers
9k views

Is there a dynamic sorting feature in Excel 2007/2010?

I have a task list spreadsheet that I maintain. Each task is given a ranking based on number of days until due date, weighted by high, low, or medium priority. The ranking is automatically calculated, ...
1
vote
2answers
14k views

In Excel, How to sort a column and keep respective values in other columns

How do I sort a column according to ascending values in excel, while keeping the respective initial value in the other columns on the same row? Column A shows the name of a subject. Column B shows a ...
3
votes
1answer
354 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, ...
0
votes
1answer
110 views

Excel rearrange data and sort

i have a table in excel with data in this format (with alot more data): date source data1 data2 1.2.3 1 767 888 1.2.3 2 543 444 2.2.3 1 557 333 2.2.3 3 576 777 It ...
1
vote
2answers
1k views

How can I sort a long list of text alphabetically?

How do I sort rows of text alphabetically without using specialized third party software or plugins (like Notepad++/Word/Excel/et al)? I suppose what I'm perhaps asking is -- How do I sort rows of ...
0
votes
1answer
605 views

How can I permanently divide / separate files, folders, and shortcuts on Windows 7 desktop? [duplicate]

Basically I want to devote a flexible, visibly divided fraction of my screen to each type of icon visible on the Desktop (files, folders, shortcuts). What will I (or someone much more skilled than I ...
2
votes
3answers
398 views

weird filename sorting (bash, ls, sort)

Good day, everyone. I'm trying to feed my music to mplayer, like this: mplayer *, but getting wrong track order. Here's what I get with ls (as well as ls -1, ls -1 | sort), note the order of the ...
0
votes
1answer
82 views

How to sort an Excel column using the following characters

I have a column with letters W and E following numbers, i.e. 4e 5w 6w 7e 7e , and I want to sort the column into e and w. Any help would be appreciated.
1
vote
2answers
325 views

How to manually sort files in win explorer?

I want to manually sort (drag and drop) my files in a certain (not in all) folders (win xp sp3). Is there any fix to do it ? If no - is there another file explorer with the feature.
6
votes
4answers
2k views

I need an easy way to 'google' through all my PDF files - anything like this exist? [duplicate]

Here is my scenario and system: System: Win-7, 64-bit. Scenario: Very simply, I have a folder on my dropbox account, titled \Papers. Within this folder, I have a lot of PDF files, and I have even ...
0
votes
1answer
89 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
374 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
4k 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
4k 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
876 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
637 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
339 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
1k 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
455 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
856 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
321 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
765 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
506 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
97 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 ...