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
5k 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 ...
9
votes
3answers
15k views

fatsort for Windows 7 [closed]

I've used a program in Linux called fatsort to reorder the directories on my USB flash drive so that my car stereo navigates folders in alphabetical order instead of random order. Is there any ...
0
votes
3answers
17 views

How do i align multiple columns in excel by name and sales?

Please ref attached image. I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third ...
2
votes
2answers
100 views

How to sort java's .property file containg <key> = <value> by <value> column?

How can I sort this property file from java project by its value column? The value contains tabs or spaces before or after the value. Here is how this file looks like, key1 = value1 key2 = ...
0
votes
0answers
21 views

Group files by the specific day they were created on Windows 10

It would be very helpful to group files in Windows 10 file explorer by the specific day they were created. When someone tries Group By > Date Created in large icon view, they get useless, and vague ...
0
votes
1answer
37 views

How to sort a text file with three columns, each separated by a comma?

I have a text file as such, 1151,1000,801; 1152,3000,801; 1154,1000,801; 1156,3000,170; I'd like to sort based on the third number in each row. How can I do this?
2
votes
1answer
18 views

Is there something about filling Excel spreadsheet cells with CTRL+SHIFT+ENTER that prevents a successful sort?

I have a long list of entries that I want to sort randomly. I highlighted a column, typed in =RAND(), and then pressed CTRL+SHIFT+ENTER, and voilà, my column was filled with random numbers. I then ...
1
vote
2answers
8 views

Sorting files by “line content” frequency

Imagine that there are 3 text files. 1.txt: a b c 2.txt: f c d 3.txt: b c f How do I sort them by frequency of each "line content"? (In case of collisions alphabetically) Result: c b f a d
1
vote
0answers
24 views

How to sort by date modified ascending ALWAYS in Windows?

How to force Windows to sort always by date modified and always ascending? The situation is that often 1) Modified field is Off (not listed in Sort By menu by default) 2) Once opened More menu ...
0
votes
2answers
62 views

Sorting data in Microsoft Excel when each item spans a variable number of rows

I have an Excel sheet that I use to keep my users' 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 ...
1
vote
0answers
16 views

Implementation of qsort [closed]

I have been looking for implementation for qsort but using google I find implementation for something like this void qsort(int[] arr, int left, int right); What I want is implementation for ...
0
votes
2answers
34 views

Bash - sort by not first character

I want to sort my file by first column but I have to start sort from 5 character. How can I do that? My file: "TTTTCTTACA" 1 1 "TTTTCTTACC" 1 "TTTTCTTACT" 1 ...
0
votes
1answer
41 views

sort -V on Mac OS not working?

Sort -V works on Linux (which means natural sort of version numbers within text) and looks like there is no -V option on MacOS? Any alternatives? regards, Lin
2
votes
1answer
93 views

Please explain how to use sort command in unix

I am new to UNIX. Please explain sort command. I have doubts related to sort field separator. E.g.: sort -k2, 2 filename, Please clarify. Please provide small example.
0
votes
0answers
24 views

In Excel, how would I sort by specific data

If I have a ROW of multiple reoccurring inputs (text), and I need to continually sort by only those specific names, is there a way in which I can automatically sort only by those names which I request?...
0
votes
2answers
22 views

Sort specific media folder with date modified

I have tons of mp3s in my default Audacity folder and would like to sort them by date modified without changing the folder to general and while keeping the music info coloumns. Thanks in advance.
0
votes
2answers
2k 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 ...
0
votes
1answer
45 views

Excel 2016: sorting different than what expected

Let's say I have filled a given column with values that contain text followed by numeric values. Whenever I try to sort the values (smallest to largest), I get the following result: Picture 1 ...
0
votes
1answer
13 views

Strange behaviour when sorting IP addresses. (sort -nu)

I just tried to |sort -nu (numeric & unique) a list of ~30 or so IP addresses and noticed that in addition to culling duplicate lines, it's treating similar lines (i.e. addresses with the same ...
0
votes
0answers
29 views

How to sort filename duplicates numerically, with unnumbered filename first?

I have a list of files with the same name, but with numbers appended (see image). Like this: Target practice (01) Target practice (02) Target practice (03) Target practice How does one make ...
0
votes
1answer
40 views

bash sort from the end of string

I want to sort file by first file, but the last character is the most important. For example form file: "AAAACTTTTT" 1 2 "AAAACAAAAA" 1 2 6 4 To: "...
3
votes
2answers
4k 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?
0
votes
0answers
13 views

Global columns playlist sorting script for Foobar2000?

I use Columns UI and Columns Playlist, and there is a sorting algorithm that is prioritizing artist name above all else, so it's messing up the track order and putting them in a 2,4,6,8,1,3,5,7 order. ...
0
votes
1answer
29 views

Efficient way to sort/organize images?

I've built a site for someone who has about 100,000 clients, each with their own 'listing' which is searchable. When you click on a listing for more details, each listing may have anywhere from 0-6 ...
4
votes
1answer
80 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
4answers
56k 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 ...
-1
votes
1answer
33 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
156 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" " "; ...
2
votes
16answers
83k 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
40 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
30 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
13 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
38 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
170 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
30 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
32 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
85 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
31 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
45 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 /var/...
0
votes
3answers
3k 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
15k 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
9 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
29 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
18k 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
121 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
232 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' original....
0
votes
1answer
57 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. ...