Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
721
questions
0
votes
2
answers
66
views
Why some cells can not be sorted in Excel
I am met with very strange things with spreadsheets in Excel now. Some cells with a date like 2023-10-22 can not be sorted with other cells in the same format in a column. I changed the format of the ...
1
vote
2
answers
53
views
How can I sort my file by date if there are different number of spaces between the name and date?
How can I sort my file by date if there are different number of spaces between the name and date?
My example file:
Ivanov 03/01/1980
Petrov 10/05/1992
Sidorov 21/07/1985
Kovtun 15/...
-1
votes
1
answer
68
views
Sorting grouped cells in excel based on one column with alpha and numerical values
So my original dataset is structured such that each row represents one street and then there are three sets of columns that represent a recommendation for a design feature to change (like add trees), ...
1
vote
1
answer
33
views
Put numbers in Ascending order then label them (highest to lowest) 1,2,3 etc in next cell
I have a small list of numbers in no particular order in a column
900
465
650
1125
800
1212
545
in the cell next to each I want to show were each number comes in ascending order 1,2,3 etc (highest to ...
0
votes
0
answers
28
views
Sort by none/disable auto-arrange in Explorer doesn't exist or does not work
Unchecking Sort By "Name" seems to be disabled. Is there any way around this?
This is EXTREMELY limiting and frustrating in Windows 10, in fact, anything past Vista. No matter what I do to ...
0
votes
1
answer
90
views
Is it possible to have mulitple inboxes in Thunderbird as in GMail?
I would like to have a feature similar to what I currently use in GMail:
one inbox with all unread email;
one inbox with all starred email;
one inbox with everything else.
Note that all these ...
2
votes
1
answer
78
views
Sorting a Wikipedia table by numerical value in a text document?
I've been working on a 3474 line table. Getting the information was easy, capturing the needed information from public online sources. But I came across a problem.
The table is by default sorted ...
0
votes
1
answer
78
views
How to create a sorted table summary of the count of a categorical column in Excel?
I have a dataset like:
Animal fruit
cat apple
dog grape
cat cherry
cat pear
dog cherry
horse melon
cat lemon
I would like to create a summary table counting each occurance ...
0
votes
2
answers
137
views
Sorting each group of data based on the values on a column in Excel
My data is look like,
As you can see, I used the label column in order to group my data and rows with the same label belongs to the same group in this way. Now I want to sort each group based on data ...
0
votes
1
answer
41
views
bash sort by numeric substring
In bash shell I'm trying to sort by a numeric value at the end of each line (sort by number of packets)
Tried to use "sort -k6 -t '=' -n but not working.
Input:
type udp ip src=192.168.2.173 ...
2
votes
2
answers
162
views
Sorting files and folders by hexadecimal and decimal values
A while a go I needed to figure out how to sort my files by hexadecimal order. I found some very useful information in this awesome answer:
Adding "NoStrCmpLogical" as DWORD with a value of ...
1
vote
1
answer
185
views
How to Sort and Move Files Based on their Extensions on Windows
I'm trying to sort and move files based on their extensions within Windows, and am following this tutorial using:
@echo off
for %%a in (".\*") do (
if "%%~xa" NEQ "&...
0
votes
1
answer
76
views
What are version and revision of a file?
The docs for the nnn file manager says that nnn is able to sort a list of files on the basis of:
apparent disk usage / disk usage / extension / revision / size / time / version
But what are the &...
0
votes
1
answer
182
views
Outlook Online: I can’t seem to filter according to sender
Outlook Online: I can’t seem to filter according to sender!
I am working with Outlook online, chrome browser, from a desktop—not a phone app / Mac OS.) I did check some community answers, But I didn’t ...
1
vote
1
answer
72
views
Difficulty performing complex sorting when listing files in a directory with the ls command
The behavior I'm seeking is a nested sort with the ls command where sorting by one method doesn't cancel out sorting by a second method. The exact desired behavior is essentially:
First sort with ...
1
vote
1
answer
92
views
How can I arrange arbitrarily folders in Windows 10?
I want to sort some music folders by the release date, so I was wondering if there's a way to edit the metadata of the folder, because looking on the sort options, there's a "year" column, ...
0
votes
0
answers
63
views
MS Access table not sorting by primary key
Environment: MS Office LTSC Pro Plus 2021 under Windows 11 Pro 64.
I have an Access table with 300,000 records and 28 fields, including an autonumber primary key. Yesterday, after adding the 28th ...
3
votes
1
answer
257
views
How can I make new subfolders created in a directory inherit the parent folder's sort type as default (such as "date modified")?
So I have a folder within which new folders containing images are frequently created. These images are frequently updated, and I prefer to set them to sort by "date modified" so the most ...
1
vote
1
answer
493
views
Editing rules in Outlook 365
I have a list of 30 rules to sort incoming mail on my POP3 and IMAP accounts, and move them into relevant folders (or permanently delete the known spammers).
Such a large set of rules didn't happen ...
0
votes
0
answers
753
views
Excel: How to best sort/match two (+) columns with a different amount of rows?
Hello I am trying to figure out a few different ways to accomplish this, to find the most efficient approach. Any and all help appreciated.
Here is one workaround I found but cum er some and does not ...
0
votes
0
answers
26
views
Sort information in Excel displayed in "cards" [duplicate]
I'm looking to create data "cards" in Excel which is a way to visually display information next to an image:
The reason to display information this way is because I want to always be able ...
0
votes
0
answers
2k
views
In an Excel PivotTable, how can I sort by multiple row fields?
In Excel PivotTables, it's easy to sort, say, the rows by the major row field: There's a "Row Labels" column with a menubutton on the side, you click it, and you get sort options, just like ...
0
votes
0
answers
37
views
Sort text and numbers in Excel so the numbers sort properly?
I've created an inventory of my watercolor paints. Paints use pigment categories and pigment numbers. For example, blue pigments all start with the pigment category PB (pigment blue), followed by the ...
0
votes
1
answer
324
views
Powershell: sorting directories based on file count
I am attempting to create a list that counts the number of files in a folder and then sorts the order of the folders based on that count. I have the following but it doesn't work (i.e. doesn't sort):
...
0
votes
1
answer
357
views
Column sort is not putting numbers in the correct order
I am uploading a .csv file into a third-party program with the following data for example:
When the (third party) program sorts this data by the 'Number' column it looks like it is sorting the column ...
3
votes
1
answer
98
views
Alpine email client does not sort alphabetically
How can I get the Alpine email client to correctly sort From? I am using Alpine v2.21 on Ubuntu 18.04 LTS server. When I attempt to do so for a folder by typing the '$' key and selecting 'F' for 'From'...
1
vote
2
answers
463
views
How to sort folders by icons, rather by name of folder?
I created icons that are labelled with numbers, but I would like to name them not by the associated number.
It creates a problem because the icons will be alphabetically sorted and in thus in disorder....
0
votes
2
answers
1k
views
Powershell script Select sort output by number
The following powershell script outputs a server diskspace report.
Is there a way of sorting the 'Percent' data in either desc or asc order?
[Script]
$computers | ForEach {
$Disks = Get-WMIObject ...
0
votes
0
answers
124
views
What order are wifi-networks displayed in windows?
When you open the wifi menu on Windows, the order of the networks seems random. What order are they meant to be in?
1
vote
2
answers
949
views
Correctly sort semantic version list using Excel
We use Excel to export summaries/ticket lists from our bug tracker. The column I would like to sort by is the "version" column. We use semantic versioning (https://semver.org) because of ...
0
votes
2
answers
25
views
Sort out whose who are still working by date
I have an Excel file with 4 columns: Name, Staff_No, Date_Joined, Date_Left.
My boss wants to know those who are still working.
The output should look: Name, Staff_No, Date_Joined.
Any idea for the ...
1
vote
0
answers
242
views
Mac is not sorting by filename correctly (Not a Group By or Arrange By issue)
I've noticed a strange sorting issue on my Mac OS in Finder. I have image files with the following format:
PROJ-202301-General-{random 5 char string}0{maker name}{datetime stamp}{title}.jpg
I have ...
0
votes
1
answer
162
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
0
votes
0
answers
147
views
Extract files in order by numbers at end of filename (windows)
I want to use a Windows .bat file to extract a number of files in a folder.
I have files with numbers at the end of filename, just before the extension, and I need to extract them in order of these ...
0
votes
1
answer
873
views
Windows 11 File Explorer file name sort order - getting a file to the top
I'm creating an archive of a web site and within each directory (folder) I have a file called !THE_PAGE_TEXT.html which is basically a readme file for that directory's contents.
I want that to appear ...
1
vote
1
answer
108
views
Making the VBA code affect a specific range of pages
I have this very simple code
Sub SortByTime()
'
' SortByTime Macro
' Sort by Time
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Range("C4:J43").Select
ActiveWindow.SmallScroll Down:=-36
...
0
votes
1
answer
603
views
UNIX or Linux sort: only sort on the first part of an entry
I'm working on a complicated grep, something like grep -E -i "first|next" *.txt, and I get results like:
logs.10.txt:2022-10-07 10:33:05.6673 | ClassName | [Info] | Inside function first(), ...
0
votes
1
answer
759
views
Windows-11 File Sort Command to view all files within subfolders
I used to use a sort command when trying to view all files across a bunch of folders at once. It makes sorting files easier. I do know part of the command was written as not sort kind, I may even have ...
0
votes
1
answer
543
views
How do I fix a sorting issue not related to numerical sorting in Windows File Explorer?
I'm familiar with numerical sorting where the issue is a number as a value or a string. I'm asking a different question.
I'd like to sort files in a way such that the file that includes a string after ...
1
vote
1
answer
97
views
How can I best reorder data in mixed row/column format into a simple table?
I have (from a CVS file) data in the following format:
The data is a continued list (row by row of comma separated values) where in arbitrary locations columns are inserted or removed. At these ...
1
vote
0
answers
611
views
Sort files manually
I've got one simple problem (and expected one simple solution, which I didn't find).
I would like to sort files manually (drag and drop) on Windows 10.
I've read a lot of workarounds (e. g. renaming ...
1
vote
2
answers
2k
views
Sort column by first two letters
I would like to sort a column but only based on the two first letters. When the two first letters are the same, I would like to sort on another column.
This stackoverflow answer mentions this solution:...
0
votes
1
answer
295
views
Linux shell - Sort on a numerical column
I'm using the linux shell in a jupyter notebook. I'm trying to filter rows of a .csv file to only keep those including 'Government expenditure on education, total (% of GDP)', then to only keep ...
1
vote
1
answer
68
views
Sort slicers data in excel
how can I sort data in slicers as shown in this photo
0
votes
2
answers
1k
views
Group Outlook tasks by due-date categories: "Today," "Tomorrow," "This Week," "Next Week," etc
I use Outlook's Task "peek" to organize my to-do list. When I let Outlook "Automatically group [tasks] according to arrangement," as in this picture—
—it groups them by the ...
0
votes
1
answer
677
views
Why do these sort in different order?
I expect 01 to appear first or last in both of these sorts but actually changing the length of the second record changes the sort order. Why?
$ { echo 01; echo 0_12; } | sort
01
0_12
$ { echo 01; ...
0
votes
1
answer
26
views
Sorting in excel with additional conditions
I have several rows of objects, each row with a specific date.
Currently, the spreadsheet is ordering the rows by date increasing, using the ROW function.
However, I need to introduce a new ordering ...
0
votes
2
answers
824
views
How to modify search order for ALL folders
what I mean by this is when you right-click in a folder, there is an option "More" By default, the only time-based sorting is Date Modified which takes very long, sometimes half a minute and ...
0
votes
0
answers
78
views
Different sorting by name in Windows Explorer and other Apps
i noticed Windows Explorer and many apps like Winrar sort folders by name like this order:
(test
)test
.test
@test
_test
+test
0test
1test
atest
-atest
but in some other apps like 7z and unlocker, i ...
1
vote
2
answers
413
views
Excel / LibreOffice Calc: find item in column with latest first occurrence?
In a Calc or Excel sheet I have a column with bunch of names. Each name can occur one or multiple times.
Each name has a 'first occurrence' i.e. the first row in which it appears.
I'm looking for an ...