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
4k views

Sort doesn't work properly for cells with references to other cells

I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table: For instance, the value of the first cell in the ...
0
votes
0answers
15 views

How to keep a value locked when filtering

I am trying to create a single list in excel containing a number of different groups. Within those groups I was hoping to lock some values into the order of their subset so that the order of each ...
11
votes
4answers
8k views

Windows 7, any way to sort folders and files all mixed together?

Is there a way to sort folders and files by their name all mixed together in Windows 7? It would be easier to understand if you look at this page. I want my folders and files arranged like the ...
2
votes
3answers
13k 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
2answers
31 views

How to disable automatic sorting in Windows 10?

I want to be able to arrange files in the file explorer in a certain order. Is there a way to disable the automatic sorting feature for folders? It is possible to disable automatic sorting on the ...
6
votes
1answer
2k views

Excel 2013, can data be re-sorted automatically?

Is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically ...
7
votes
2answers
1k 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 ...
2
votes
2answers
406 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 ...
3
votes
1answer
16 views

Sorting Excel Rows & Columns into descending order of activity

I have a spreadsheet with 45 rows and 85 columns. Not all 85 columns contain information. Some rows will fill all 85 columns, some rows only fill 40 or 50 columns. Is it possible to sort the ...
0
votes
1answer
7 views

Unix shell: Multi-level sort in opposite directions

I have a directory full of plain text files that have tags on the first line, and I want to get a list of the tags and their frequency. I've extracted the tags and sorted them into a big list; let's ...
0
votes
0answers
9 views

How to sort spreadsheet by date+time column but with a modified hour column? [migrated]

I have a spreadsheet generated by a google webform and it produces a standard spreadsheet with a full timestamp column that is two hours behind and a hour column (hh:mm am/pm) that the user fills in ...
0
votes
0answers
5 views

Retaining the order of a .bib-file when applying changes using Jabref

Short introduction to the problem: In my group, we work collaboratively on one single .bib file to keep all the references at one place. If one of the collaborators edits the .bib file, the order of ...
0
votes
1answer
45 views

Cannot sort Excel Pivot Table by two or more columns

I want to sort my Pivot Table by two columns. I've searched the web for some time, and it seems Excel doesn't allow this, so I need a workaround. My data Desired Outcome I want to summarise this ...
1
vote
1answer
18 views

Sorting a comma separated file by the first column while preserving some order

I have a file of the form: kl2,LL kl2,nan kl2,MORE kl2,PRQ kl2,JJ abc87,PRQ abc87,JJ abc87,nan abc87,MORE abc87,LL ... and I would like to sort this by the first column, while leaving the second ...
0
votes
0answers
48 views

Excel 2010 VBA AutoFilter and AutoFilter.Sort criterion not applying

I'm having a heck of a time getting AutoFilter criteria to apply, both the filtering and sorting. I'm trying to get rid of blank rows and filter over multiple criteria - simple, right? Except it ...
4
votes
2answers
63 views

Is there an add-on for Excel to allow me to sort by an arbitrary column with a SINGLE click?

Windows Explorer allows you to sort by an column by clicking on the 'header' of that column so you can see files sorted by size or filename etc. Excel on the other hand forces you to go through the ...
1
vote
4answers
27 views

UNIX Command to sort file based on word delimited

I have a file that has lines file.txt like this: www.site.com/230207|Sophie Rundle title: Episodes|5irko3ke www.site.com/228264|Camilla Luddington title: Balifornication|5423234 ...
0
votes
1answer
43 views

How to sort only selected desktop icons by name? (Windows 10)

I am running Windows 10, and I have many icons on my desktop. I would like to sort some of them (by name/date/etc), but when I Right click on my desktop and then do Sort By > Name all of the icons get ...
1
vote
1answer
95 views

Excel Sort and Lookup Values Formula

I am trying to create some sort formulas on excel. An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...
0
votes
1answer
67 views

Excel will not sort all columns on my worksheet

I have a very basic worksheet with multiple columns and rows. I usually will sort one column to sort a-z and normally all data for those rows would follow the sort. Suddenly I am finding that if I ...
1
vote
0answers
44 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 ...
0
votes
0answers
40 views

Splitting .csv File Based on Values in Other .csv File

I have two .csv files. One contains a string in the first column, then a number per column for several columns after that, like so: ABU_1102;1162;1165;1167;1168 AFG_1220;1214;1215;1213;1212;1211 ...
-1
votes
1answer
30 views

Text Data not sorting as desired

ESXi 5.0.0 ESXi 5.0.0 ESXi 5.0.0 ESXi 5.0.0 ESXi 5.0.0 ESXi 5.5.0 ESXi 5.5.0 ESXi 5.5.0 EXSi 4.0.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 5.0.0 EXSi 5.0.0 EXSi 5.0.0 ...
0
votes
1answer
37 views

Excel: Copy all cell values from an entire sheet to a new sheet, sort and deduplicate into a single list of unique values

The data (all text values) I have is scattered across the sheet (multiple rows and columns with gaps inbetween) and it is all calculated using formulas now I would like to make sure that I know what ...
1
vote
2answers
637 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 ...
2
votes
2answers
49 views

Unix vs Excel sort

I have the following list of files sorted according to Excel: a1.txt a10.txt a11.txt a12.txt a2.txt If I use sort on Unix/Linux, I get the following order: a10.txt a11.txt a12.txt a1.txt a2.txt ...
1
vote
1answer
36 views

Firefox sort history based on time

Sadly it only seems possible to sort history on date After collecting all sites of today (way too many) Firefox orders the history alphabetically. I want to sort only on time and date. Like with ...
0
votes
1answer
23 views

open files in sorted order (OSX)

I'm looking for a terminal command to open many files in preview in "sorted" order. I'd like to open the files in order: 1.pdf, 2.pdf, 3.pdf, 4.pdf, etc. But without first sorting, they are opened ...
0
votes
0answers
28 views

Sorting large fixed-length record file

It is easy to sort a large (=does not fit in memory, fits on local filesystem) text file using GNU sort. When necessary, GNU sort will start doing external merges. How do I sort large files where ...
21
votes
7answers
23k views

In bash, how to sort strings with numbers in them?

If I have these files in a directory cwcch10.pdf cwcch11.pdf cwcch12.pdf cwcch13.pdf cwcch14.pdf cwcch15.pdf cwcch16.pdf cwcch17.pdf cwcch18.pdf cwcch1.pdf cwcch2.pdf cwcch3.pdf cwcch4.pdf cwcch5.pdf ...
0
votes
1answer
32 views

Sort excel table (multiple columns) by numeric column

I have this table from program profiling: I need to sort it by Total column. But instead, the Excel sorts the numbers alphabetically. I can't even believe it's that stupid. Just check it out! Of ...
0
votes
0answers
38 views

Windows Explorer: custom order for sorting by type?

Is it possible to modify the exact order in which files are listed when sorted by type in Windows Explorer? Not just choosing between ascending/descending, but sort differently? For instance: 1. To ...
28
votes
2answers
74k views

How to UNIX sort by one column only?

I know that the -k option for the Unix sort allow us to sort by a specific column and all of the following. For instance, given the input file: 2 3 2 2 1 2 2 1 1 1 Using sort -n -k 1, I get an ...
-1
votes
1answer
77 views

Excel auto sort rows?

I know how to sort rows given their value, however as I keep adding new rows the values keep changing and I would like Excel to auto sort every thing I add something. On sheet 1 I have a table like ...
0
votes
2answers
13k 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
0answers
40 views

Sort list into tuples in Excel

Is there any way to sort a list into tuples as defined by a priority list in Excel? For example I would do a draw to get priorities: Banana -> 1 Apple -> 2 Tomato -> 3 And I have sheet of ...
0
votes
2answers
24 views

How to sort text file by labeled field?

I have file with line format as follows: <something> <file_name> type:file <something> size:<filesize> <something> I would like to sort numerically it by the field ...
1
vote
15answers
60k 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 ...
0
votes
1answer
19 views

How to mass format window files sorting and view style for my entire computer?

When going into a folder of a window, I usually do 1) right click > view > list, then 2) right click > sort by > type. It gets annoying when I have to do this every time I am in a new folder, and ...
4
votes
1answer
2k views

Case insensitive sorting

Vim's default sort is case sensitive, and produces results like this: A B a How can it be made case-insensitive, to produce the following result given the same input? A a B
53
votes
11answers
38k views

How to sort first directories then files etc… when using “ls” in Unix

I would like to use ls command to first show direcotries and then files. I tried ls -la | sort -k 1 But I got a wrong order.
1
vote
1answer
142 views

Sort folder full of shortcuts by Destination property in Details view?

scenario I'm on Windows 8. I have some folders that contain .lnk files. problem I would like to know if I can sort the files by the destination in the Details view column of the explorer. I ...
74
votes
1answer
58k views

Sorting lines in Notepad++ without the TextFx plugin

The current version of Notepad++ (at the time of this writing) is 6.6.3. Version 6.5.2 is the first that introduced a native (without a plugin) sorting function. At least, that's what they claim; even ...
2
votes
3answers
1k views

Is there a way to preserve or remember sort-by preferences for different folders in column view in Mac OS X?

For example, I would like to have folders in column view, and to have Folder 1 always to show files sorted by kind, and Folder 2 always to show files sorted by date created. I'm running Leopard, with ...
2
votes
3answers
27k 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 ...
1
vote
2answers
73 views

When your field-terminating char appears within field values

I've had a very colorful morning learning the innerparts of Linux's sort command, and have come across yet another issue that I can't seem to find an answer for in the documentation. I'm currently ...
0
votes
1answer
35 views

mc - Midnight commander - How do I sort so that directories are on top?

By default, mc sorts so that the directories are on top (come before files). Somehow, I've changed this so that the directories are sorted alphabetically. Where is the option or keyboard shortcut to ...
1
vote
0answers
22 views

Microsoft Word: Sort Document Headings alphabetically

I have a document that contains Names syled in default Heading 1 and some normal Text below similar to. Busta Rhymes Trevor Tahiem Smith, Jr., better known by his stage name Busta Rhymes, is an ...
0
votes
1answer
47 views

excel: how to place rows at the bottom of list in sort and filter options?

Here is what I have at the moment: Click on home ribbon button click sort & filter drop down box I have a sort option as follows: As you can see the rows have been commanded to go to the top ...
2
votes
1answer
28 views

How can I make unix sort work properly using the underscore as a field separator?

When I sort foo and foo1, I expect foo to come first, which is what happens ordinarily with unix sort. $ echo -e "foo1\nfoo" | sort foo foo1 But when I add and underscore and use the -t and -k ...