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

learn more… | top users | synonyms (1)

3
votes
1answer
33 views

Sorting data without mixing rows

I have three sheets. First sheet renamed General: Dave Henderson 21/05/2014 Elton Rus 22/06/2014 John Smith 20/05/2015 Second sheet renamed ...
2
votes
5answers
52k views

Excel Sort Numeric Column By Number

I have a column of integers in my spreadsheet, and the column is formatted as a number. Each cell inside the column is formatted as a number. But I can't seem to sort them in numerical order - you ...
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 ...
-1
votes
1answer
29 views

excel, auto sorting/deleting columns that are far apart

I have a long list of people with specific criteria, and i need either a macro, or a function in the background that every month when i update this list (delete old and coy paste info in thats new) ...
3
votes
2answers
139 views

I need to sort a list of bullets (and sub bullets) in alphabetical order

I have an issue with word's alphabetical sorting. Here is an example of what's going on: Question 1 Answer 1 Question 2 Answer 2 When I press sort, this happens: Question 1 Question 2 ...
3
votes
2answers
4k views

Find all duplicate files by MD5 hash

I'm trying to find all duplicate files (based on MD5 hash) and ordered by file size. So far I have this: find . -type f -print0 | xargs -0 -I "{}" sh -c 'md5sum "{}" | cut -f1 -d " " | tr "\n" " "; ...
1
vote
16answers
75k 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
14 views

How do I sort merged cells linked with other data?

I'm making an inventory excel and I'm trying to sort these orders by state. However, some orders have multiple items and thus, I merged the state because 1) better viewing and 2) When I add up the ...
1
vote
0answers
33 views

Any way to do Linux-style sort --merge in Windows PowerShell?

In PowerShell, if I have two files that are already sorted and want to merge them into one big sorted file, it seems wasteful and inefficient to do gc file1, file2 | sort-object > newfile, ...
1
vote
1answer
24 views

Sorting Text alphabetically using last word before comma

I'm currently ordered to sort a list with ~250 entries alphabetically. Problem is: Not using the first word(s), or a specific column, but using the last term before the first comma: [li]title ...
0
votes
0answers
11 views

How to sort four columns with two diffrent values

I have four columns, I want to sort by the names and have the amounts also sort with the names. Can anyone please assist Column A Column B Column C Column D BOGOSI 55.00 BOGOSI ...
0
votes
1answer
28 views

MS Excel Sorting by rows but keeping same data in same column

I have data like this: But want it sorted like this: How can I achieve this?
2
votes
2answers
125 views

Conditional formatting on the first x number of rows, regardless of filter or sort, in Excel

I'm trying to find a way to easily identify the first ten rows in a table column, no matter how it's been sorted/filtered. Is there a way to use conditional formatting to highlight these cells? ...
0
votes
1answer
25 views

how to sort the data with defined min and max value

I am looking for generating the number of entries which fills into defined min and max values from the given data. To put it more simple, If the data set is Roll No: 1, 2, 3, 4, 5, 6, 7, ...
0
votes
1answer
24 views

Excel doesn't sort columns to the right of a blank column

If you try to sort on a column when there is a blank column in the spreadsheet, only the columns to the left of the blank column will be sorted. How can this be changed so that all columns are sorted ...
1
vote
2answers
52 views

Sort Excel Pivot Table by Percentage of Count

I have source data showing timesheet approvals in the following format (for about 850 employees and 200 managers): Employee Name Manager Name TS Approved? Employee 1 Manager 1 No ...
0
votes
1answer
26 views

How to Sort a Pivot Table based on two columns of information

I work in the Auto Industry where I have to create a Pivot Table based on Auto information each month. The Sort Order of the Pivot Table needs to be Model Series Door Cylinder Model ID Code Trim ...
1
vote
3answers
39 views

Sort by `ls -l` Dates Without Using `ls`

I have a text file with a bunch of ls -l output, such as: -rw-r--r-- 1 root root 7554952082 Dec 15 22:11 /var/spool/stuff/Investigation/messages.tgz -rw-r--r-- 1 root root 4315 Mar 3 2015 ...
0
votes
3answers
1k views

Using Excel and Sorting Data

I have a spreadsheet with over 1500 rows and 20 columns, in column C I have manufacturer as my header and below it 1500 listed names, one for each row. How do I extract the names into a single ...
5
votes
3answers
14k views

How do I change the default sort order on Windows Explorer and the File Dialogs

My file dialog shows files sorted by date and I want it to sort alphabetically by filename.
0
votes
0answers
7 views

Sort Outlook messages by subject without having to go to top in Outlook 2007

Outlook 2007 - When on a message, I want to click and sort by subject without always being forced to the top, i.e. subjects that start with A, rather I want to be able to stay on my current message ...
6
votes
2answers
1k 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? ...
0
votes
1answer
25 views

How to sort a column (Y) for each group in column (X) in excel 2013

Is it possible to sort a column (Y) for each group in column (X) such that even values in column (Z) are changed? I have about 23000 rows so manual sorting for each group is difficult. I have attached ...
3
votes
3answers
16k 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 ...
0
votes
1answer
61 views

Excel - Sort by formula when there are duplicate values

My data will change, therefore I am using dynamic lists. Sorting needs to be dynamic as well. I do not want to click on the built in sort function. I'm sorting dynamic data by formula, but it fails ...
2
votes
2answers
228 views

SORT empties my file?

I'm attempting to sort a csv on my machine, but I seem to be erasing the contents each time I use the sort command. I've basically created a copy of my csv lacking the first row: sed '1d' ...
0
votes
1answer
37 views

Windows 7 or 10: Explorer Sort Order - distinguish between normal Explorer vs. Open-File/Browser windows

Is there a way to make Windows (7,8,10,whatever) remember a different sort-order for displaying your files in regular Explorer windows vs. open-file/file-browser dialog windows? To give an example. ...
0
votes
0answers
10 views

Add tags on android pictures

How to add tags that could be seen on Linux system? When upload photos need automatic sorting by tags. Default tags on android doesn`t work.
0
votes
2answers
35 views

Excel sorted heading won't sort data in whole spreadsheet

So I would like to be able sort all my data using the little drop down arrow created by the filter function, all the way from F to JE. At the moment it will only sort from F to AK. Any idea how I ...
4
votes
3answers
2k views

Windows Explorer sorting order for special characters?

What is the sorting order used in Windows Explorer? I was specifically wondering what special characters sort after the alphabets? As far as I can tell (test), all special characters seem to be ...
0
votes
1answer
46 views

Sort files and folders in the same way in Windows Explorer - sorted by names [duplicate]

I just want to see files and folders (sorted/grouped by their name) in a list that does NOT separate files and folders. I also don't want to order by date modified like here. I already tried several ...
0
votes
2answers
33 views

How can I sort Excel cells in groups?

I have something like the following, but over 1000 rows. Further down some of the blue headers have multiple white inner cells. Now I know I can do grouping, but if I select row 1 and 2 and group ...
0
votes
1answer
34 views

Sorting in Microsoft Excel

When I use the Sort "oldest to newest" in the Filter dropdown and I am sitting on, for example Row 400. After I do the sort my screen resets so I am sitting at the top of the spreadsheet instead of ...
-3
votes
1answer
44 views

Deleting multiple rows selectively from Excel 2010 [closed]

I have 19,000 datapoints in each row, now my problem is how to delete 20 rows simultaneously after an interval of 10 rows?
0
votes
2answers
54 views

Sorting Data in Microsoft Excel

I have an Excel sheet that I use to keep my user's information. This is a huge file and I have multiple rows and multiple columns per username. I am trying to sort the user names alphabetically ...
2
votes
1answer
499 views

Vim - Sort Nested Blocks of SCSS

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
45 views

How do I sort files by date in filename?

I have a set of filenames like this vorlesung 02.11.15.mp4 vorlesung 04.01.16.mp4 vorlesung 07.12.15.mp4 vorlesung 09.11.15.mp4 vorlesung 09.12.15.mp4 ... The last part of the file name is a date ...
0
votes
0answers
116 views

How to sort contacts alphabetically in Skype for Business

I am using Skype for Business. I observed that the list of contacts is sorted alphabetically, but by first name for some people and by family name for others, e.g.: Albert Einstein Doe, ...
19
votes
3answers
8k views

Equivalent of gnu `sort -R` on OSX?

The GNU sort text utility features a non-standard -R option to randomize input lines. OSX sort does not have this extension. Is there similar functionality available in another text filter?
68
votes
13answers
96k views

Unix/Linux find and sort by date modified

How can I do a simple find which would order the results by most recently modified? Here is the current find I am using (I am doing a shell escape in PHP, so that is the reasoning for the variables): ...
0
votes
0answers
23 views

Sorting in Pivot Table

I have problem in pivot table with sorting field which is shown as difference between years 2016 and 2015. Excel 2013 make sort with original values and I want sorting by percentage difference. ...
0
votes
0answers
19 views

Sort Thunderbird emails by sender's domain

I want to sort/group my mails by sender's server/domain. Is that possible (plugin perhaps)? I'm aware that I can use find and search using "contains" in from field, but I'd rather wanted an ...
0
votes
1answer
47 views

Thunderbird thread view - sort by star then date

So far I've been sorting my emails in non-threaded view, by star, then by date. Understand, first all starred message (sorted by date) then non-starred message (also sorted by date) Either this ...
0
votes
0answers
16 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 ...
12
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
2answers
431 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
3k 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
2k 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
442 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
40 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 ...