Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sorting]

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

0
votes
0answers
22 views

Windows 10 apps “Sort by Install Date” are not sorted by time

In all previous versions of Windows, when you sorted the installed programs by "date installed," it would sort them exactly like that - by date and TIME installed. In Windows 10, it takes all the ...
0
votes
0answers
12 views

Windows Explorer: sort by date modified with files and folders INTERMINGLE [duplicate]

This answer shows how to sort by date modified ascending. This one does similar with folders first. I wanna achieve the same but with files and folders INTERMINGLE. So they are not separated in 2 ...
0
votes
1answer
42 views

Sort spreedsheet according to groups and dates. Also leave blanks when no group size doesn't match

I have a spreadsheet that looks like: There are two sets of columns, let left one and right one are supposed to be ideally be the same (row by row), but they aren't and I need to filter them such ...
0
votes
1answer
18 views

Excel forgot how to sort my database

Years ago I created a database of my boss's clients. I always add a new client when we open a new file. It seems that in the last several days, any new clients I enter are saved out of sequence. I ...
-1
votes
1answer
54 views

How can I make columns in an Excel spreadsheet sortable while maintaining row integrity?

I notice on an existing spreadsheet that I can sort by the various columns, but only the order of contents of that column change; I want the other columns to change, too, when one column is sorted. ...
2
votes
1answer
13 views

How to sort after occurence of the / character in a text file Linux console

Say that I had a list of entries in a text file: Apple/bcd Pear/abc banana/def orange/cde and I wanted to sort these entries in the console by what comes after the "/" so they were: Pear/abc Apple/...
0
votes
2answers
42 views

Custom Sort in Excel by Specific Value

First, I've searched, but if I missed the answer to this, my apologies. I'm trying to sort a column by a number contained in parentheses. For example, I would like to sort the following Column A to ...
0
votes
0answers
57 views

Windows 10: Sort/rearrange icons in taskbar

I was wondering if there is an option in Windows, a tweak or third party software to allow arranging icons in the taskbar (currently it is possible only to drag a group of the same program, but not an ...
1
vote
1answer
66 views

How can I sort the output of awk, disregarding a certain character?

I am trying to print out the Chinese font I have in my laptop, and sort the output with respect to their name that could be referred to in LaTeX. This could be done with the following command: fc-...
0
votes
2answers
38 views

How to sort a list of numbers and null values in ascending order, with null values at the end?

I have a list of numbers and null values. How can I sort them in a way such that the null values come to the end of the list using sort in GNU coreutils? Sample Input (input.data) 0.9000 23 1 2 5 -...
0
votes
2answers
58 views

sort data by weekday

I want to analyze a large amount of data (2000>) with each singular data point corresponding to a weekday. What I want to do now is to sort my data by weekday while still having the data that is ...
0
votes
1answer
57 views

Excel — Comparing 2 lists with several columns

I have 2 lists with several columns. Each list has 5 columns, and 4/5 columns will have different values from both lists, but the remaining column is for dates. Both lists' 'Dates' Column are of ...
0
votes
1answer
23 views

Linux version sort; letters first

GNU sort -V is great for sorting IP adresses. Unfortunately it throws all lines with leading letters (as opposed to numbers) to the bottom of the pile. Is there a way around it? Note: • 192.168.0....
1
vote
1answer
71 views

Sorting output of Get-ADComputer efficiently

Powershell beginner here. I want to run a command in the terminal to list all the domain members of the specified domain with select properties, sorted by name. I have a domain with just under 400 PCs....
0
votes
0answers
12 views

One Specific Row on an Excel Worksheet Not Being Sorted Correctly

I'm having an oddly specific issue with data in an Excel sheet (download https://app.box.com/s/34xjmarn9j8jbme0f1d3shi5rctdigr4). It involves sorting by multiple column headers. All rows in the ...
0
votes
1answer
42 views

Sort all files in a folder independently, with an output file for each

I have several folders that contain numerous text files, ranging from tens to 100s. These text files are simple databases containing millions of lines, with each line containing a single record. ...
0
votes
1answer
74 views

Need Windows script to create folders named with file dates and move files to the matching folder

I need a CMD or Powershell script or batch file to step through a list of files make a folder named with the date of a file if it doesn't already exist, then move that file into its matching ...
1
vote
3answers
45 views

Spreadsheet: create column based on one column sorted by values of another

I want to create a new column of data from one column sorted by another column. It's easiest to explain with an example. This is not actually what I'm doing, but I think it explains it well. Let's ...
2
votes
0answers
49 views

Sort with case-sensitivity in macOS in the Terminal

I am trying to use the answer in GNU Sort by case-sensitive to sort a file in my Mac OS. My file.txt looks like this: "Best" "A" "BEST" In the second answer to the mentioned question, it says that ...
0
votes
1answer
26 views

How to handle spaces in directory names using grep

I have a directory tree where some of the directories have spaces in the names: top |-- subdir 1 |-- subdir a |-- file1.csv |-- file2.csv |-- subdir b |-- file1.csv ...
3
votes
2answers
173 views

How can you set up several sorting rules in Excel to sort a column?

I got a list of mail addresses, let's say we have the list thisisanexample@home.com anotherthing@whatever.com hello.world@idontknow.com default@idk.com youleave@whatever.com nomoreideas@sorry.com ...
0
votes
1answer
20 views

How to automatically sort in 1 column 2 different ranges

I don't find a short way to describe it, so the best way is to show what I have and what I want excel to do: I have this: and this is what I want as result:
0
votes
1answer
131 views

Counting t-shirt sizes in a column but also separated by commas

I am counting sizes in a column but some of the cells also have extra sizes separated by a comma. The problem I am running into is counting "L" "XL" and "XXL". The formula I am using to count "S" ...
0
votes
1answer
57 views

How to keep references unchanged after sorting

In the following spreadsheet, the references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and ...
-1
votes
2answers
558 views

Sorting files by “line content” frequency - print duplicates

Imagine there is a file - a b b b b c c d d d I want the output to be sorted based on frequency (I want the duplicate lines to be printed as well) as - b b b b d d d c c a
0
votes
0answers
44 views

Excel - how do I filter multiple tables without header?

I want to filter if any of the H I J columns contain fields greater or equal to 10.0. I don't want to use no Advanced filters because there are multiple tables across the way but I want to sort all ...
0
votes
1answer
36 views

Excel Calculate Date Differences between Orders Per Customer

I have a data-set with Account Names, Order IDs and Close Dates. I would like to see the number of days between orders, per customer, however Excel will not allow me to sort by date in my Pivot Table ...
0
votes
1answer
55 views

Trying to sort my movie list by negative and positive

i hope this is not too off topic. Tried thinking of sites to help me with this but i hope this is ok. I have a list with 553 movies, a notepad .txt file with titles formatted just like this: Shutter ...
3
votes
2answers
115 views

Align data columns in LibreOffice Calc according to numbers in another column

I have three columns: Column A contains a count from 1 to 100, representing different sample stations. The numbers are in sequence. Column B is independent of column A. It contains selected ...
0
votes
1answer
375 views

Windows CLI: sort text file by column

I'd like to sort a text file by the 3rd column of data, not the 3rd character, using pure Windows CLI commands. The commands would be put into a batch file. The data would look something like #...
2
votes
1answer
225 views

Excel: referencing a table cell

In Excel I have a table, with the first column acting as a unique identifier (I make sure there aren't duplicates). I want to be able to reference a cell of this table's first column so that: - if I ...
2
votes
4answers
517 views

Group and sort the rows of a table

I have a table where column A contains a unique value in every cell. Column B is either empty or contains a number. | A | B ---+---------+--- 1 | Gamma | 1 2 | Echo | 5 3 | Alpha ...
0
votes
0answers
295 views

Is it possible to sort images by color regardless of the file type in windows 10?

Basically, I have a folder full of color and black and white line drawings. Now I only want to keep the line drawings and I don't want to keep the color images. I could make a script to read each file ...
0
votes
1answer
64 views

Excel - Group rows by column then sort by another column

I have a spreadsheet that contains a column with people their ZIP code and another with an ID that is assigned to them. I would like to sort this sheet by the ID column, but also have all people with ...
2
votes
3answers
42 views

I need an excel formula to tell how many numbers and alphabets are in a cell

Hey Guys I need help sorting series of plate numbers out on excel. so I have a sample BMA759JA, and I need a formula that tells me how many Alphabets are contained in the cell and how many numbers ...
0
votes
0answers
9 views

Have windows explorer “sort by type”, with TeX files first?

It it possible to priorize file types when sorting in Windows explorer? When authoring with LaTeX, I roughly have this order of relevance: .tex files .inc files (for inclusion with \input). .bib, ....
0
votes
1answer
158 views

Sorting files numerically, including negative numbers

I have a bunch of files: adenine-N1_B+1,70_A+0,00.pdb adenine-N1_B+1,70_A-10,00.pdb adenine-N1_B+1,70_A+10,00.pdb adenine-N1_B+1,70_A-15,00.pdb adenine-N1_B+1,70_A+15,00.pdb adenine-N1_B+1,70_A-20,00....
0
votes
1answer
143 views

Possible to set default sort to “Type” in File Explorer using script?

Is there any way to automatically sort all files in Windows by TYPE as opposed to NAME? Generally this is done by going to a folder, sorting by type, then going to the Ribbon, View, Options, View, ...
0
votes
0answers
24 views

Simultaneously Sorting Multiple Rows of Data

What's the best way to alphabetically and simultaneously sort multiple rows of data that look like this: FL KS NC PA SC TX AL ID LA OK AK FL GA KS ...
2
votes
0answers
195 views

File Sorting in HEX on Windows?

How can I sort file names by HEX instead of whatever Windows 10 does to sort files? I have a huge list of sound effect files in a folder and because of how Windows has no option (from what I can see) ...
0
votes
1answer
44 views

How to Delete Completely Empty Columns in Excel on a Mac

This is based on the MAC version of Excel 2017. I have an excel spreadsheet with many columns. Each column has a title. I would like to know how to delete all the completely blank columns in this ...
-2
votes
1answer
80 views

Consolidate Rows in Excel [closed]

I'm attempting to consolidate and sort over 2500 rows of data alphabetically in Excel 2016, where some cells within each row are missing data. An example below (from what's on top to what's on the ...
1
vote
1answer
131 views

One-liner to sort STRUCT in MATLAB?

Seeking a one-liner MATLAB function / command to sort by date the output of: filenames = dir(filenameSubstring); % retruns struct sortrows() is for matrices and seems to rely on the sorting column ...
2
votes
1answer
78 views

How to separately sort lines within multiple “chunks” separated with headers?

This question is complementary to this one: Sort packs of lines alphabetically. After answering there, it turned out I had totally misunderstood the question and solved another problem. Not wanting my ...
3
votes
2answers
100 views

Sort packs of lines alphabetically

Note: the complementary question is here: How to separately sort lines within multiple “chunks” separated with headers? So what I did find an answer to, is how to sort lines in a text files ...
1
vote
0answers
424 views

Windows 10 sort folders with files

In Windows 10 when I filter a folder by "Date modified" the folders and files are ordered independently. I have grouping set to none. An example: If I have two files and a folder with the folder ...
0
votes
0answers
631 views

Excel - Automatically sorting

I am making a table for outcomes but I don’t know how to make my idea reality. I want to have 2 sheets. First sheet is where to write the outcomes and it should looks something like this: On the ...
0
votes
0answers
29 views

Sort values into separate columns in large datasets

I have a very large dataset with transactional data, where customerID and purchase items are not sorted into columns. I want to sort all the products/ purchase items into separate columns and indicate ...
1
vote
0answers
65 views

How to get files ordered by name with `dir`?

This used to be really easy in the old OS's. dir /o:n >> list.txt for %a in (`list.txt`) do copy %a ..\ordered And voila, there was the list of files in the other folder, created in the sorted ...
0
votes
0answers
23 views

Excel Pivot data sorting by month

I have been trying to find a way to organise and sort the data in a Pivot table in Excel by month, as in the format of the picture I attached to this question, but I have been unsuccessful so far. ...