Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
731 questions
0
votes
2
answers
54
views
Sorting issue when consolidating monthly data into a year to date file. Using query, sorting by day, time, and letter
I am collecting data from each month on measured parts into a single file for the whole year. When using a "query from folder" I am able to get all the data together, formatted, and sorted ...
0
votes
1
answer
61
views
Microsoft Photo Viewer: scroll through photos by date
When organizing photos on Windows 10, I like to scrolling through them using Microsoft Photos using the forward / back arrows. In this case the sequence seems jumbled because the alphabetical order ...
- 21
0
votes
2
answers
73
views
How to correctly sort in Excel with by custom list?
I have a list I would like to sort by. But I think the list must be sorted? My list is this:
Pu, Tsu, ʢu, Wu, Bi, Tzi, Ri, Yi, Do, So, Mo, Who, Ta, Za, Rra, ɲa
My entries are values such as:
PuDo, ...
- 3
0
votes
0
answers
16
views
Excel column sort only showing row 1
I have an Excel spreadsheet And I'm trying to sort by the first column. When I click on the down arrow to identify my search criterion, It only shows data in the first row. All other columns in the ...
0
votes
4
answers
168
views
Excel sort row with custom formula
Using Excel 2016, I want to sort my table by a row which fields MAY contain one or multiple letters at the end.
ID
3632
22895
129A
849721
84974B
290BC
I want to be able to sort this by number ...
- 277
0
votes
1
answer
42
views
How do I cancel the alphabetical sorting of bookmarks in the Opera browser?
The following scenario happened to me.
Having sorted alphabetically in the bookmarks bar in my Opera browser, I need to cancel this sorting due to the fact that, as it turned out, it did not improve ...
- 275
1
vote
2
answers
117
views
What is the full alphabetical order used on Linux and similar OSes?
Often, filenames are prefixed with characters like ~ to ensure they show up at the top of the directory when sorting alphabetically.
This begs the question, what is the full “alphabetical” order which ...
- 13
0
votes
0
answers
59
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
- 1
0
votes
1
answer
113
views
Windows sort folders differently now, and I would like the old behavior
Windows used to always show the subdirectories (aka folders) first, regardless of sort order. It seems that several years ago, this was changed. I would like the original behavior where folders are ...
- 2,009
0
votes
1
answer
92
views
MS Outlook Sortable User-defined Columns
In response to the question "How do I get rid of the "External" label in Outlook?", user Lilienthal posted a response on Jan 20, 2023 by creating a custom column using the formula ...
- 1
1
vote
3
answers
370
views
How do I sort an Excel sheet vertically = reverse the order of the full sheet = put the sheet bottom up = turn the worksheet upside down?
Data in an Excel sheet needs to be sorted the other way round. I cannot sort the data by the two columns date and time since there are some lines in it that do not have the same pattern, for example ...
- 2,531
1
vote
1
answer
205
views
Excel sort numbers smallest to largest with cells that contain multiple numbers with "/" or "," between numbers
I have a column of numbers
I want to sort the list smallest to largest numbers, but any number with a "/" or "," will be put at the end.
How can I sort from smallest to largest ...
- 213
0
votes
2
answers
159
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 ...
- 397
1
vote
2
answers
130
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/...
- 21
-1
votes
1
answer
86
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
1
vote
1
answer
92
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 ...
- 23
0
votes
0
answers
142
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 ...
- 1
0
votes
1
answer
284
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 ...
- 240
2
votes
1
answer
114
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 ...
- 23
0
votes
1
answer
179
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 ...
- 103
1
vote
2
answers
485
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 ...
- 131
0
votes
1
answer
142
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 ...
- 15
2
votes
2
answers
352
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 ...
- 2,643
1
vote
1
answer
474
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 "&...
- 17
1
vote
2
answers
157
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 &...
- 441
0
votes
1
answer
434
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
1
vote
1
answer
142
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 ...
- 78
1
vote
1
answer
199
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, ...
- 13
0
votes
0
answers
129
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 ...
- 832
3
votes
1
answer
543
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 ...
- 61
1
vote
1
answer
955
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
1k
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 ...
jds00
0
votes
0
answers
27
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 ...
- 103
0
votes
0
answers
4k
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 ...
- 10.2k
0
votes
0
answers
40
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
425
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):
...
- 1,075
0
votes
1
answer
550
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 ...
- 348
3
votes
1
answer
151
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'...
- 494
1
vote
2
answers
693
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....
- 11
1
vote
2
answers
2k
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 ...
- 11
0
votes
0
answers
206
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
2k
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 ...
- 25
0
votes
2
answers
27
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
1
vote
0
answers
567
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
330
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 ...
- 45
0
votes
0
answers
272
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 ...
- 1
0
votes
1
answer
1k
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 ...
- 103
1
vote
1
answer
119
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
...
- 45
0
votes
1
answer
1k
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(), ...
- 2,427
0
votes
1
answer
2k
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 ...
- 3