Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
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 ...
E Zhang's user avatar
  • 397
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/...
Mykola's user avatar
  • 21
-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), ...
Mari's user avatar
  • 1
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 ...
Gavin's user avatar
  • 23
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 ...
Warren's user avatar
  • 1
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 ...
J. Schmidt's user avatar
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 ...
SoWhAt249's user avatar
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 ...
Ray Larone's user avatar
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 ...
Etemon's user avatar
  • 121
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 ...
okoolo's user avatar
  • 15
2 votes
2 answers
163 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 ...
Kalamalka Kid's user avatar
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 "&...
Zolboo B's user avatar
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 &...
robertspierre's user avatar
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 ...
M Hurley's user avatar
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 ...
elucid8's user avatar
  • 78
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, ...
DanPCrz's user avatar
  • 13
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 ...
NewSites's user avatar
  • 746
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 ...
sylverone's user avatar
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 ...
Chris Bedford's user avatar
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 ...
user avatar
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 ...
Arj's user avatar
  • 103
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 ...
einpoklum's user avatar
  • 9,393
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 ...
Marina Michaels's user avatar
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): ...
Brian's user avatar
  • 1,007
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 ...
Dr_Xunil's user avatar
  • 336
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'...
Lexible's user avatar
  • 472
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....
Lu Venary's user avatar
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 ...
Bra Tabs's user avatar
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?
user15555955's user avatar
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 ...
siryx's user avatar
  • 25
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 ...
hide2may's user avatar
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 ...
Sean P Sullivan's user avatar
0 votes
1 answer
163 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 ...
Saher Naji's user avatar
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 ...
Antóin's user avatar
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 ...
KevInSol's user avatar
  • 103
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 ...
Saher Naji's user avatar
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(), ...
Dominique's user avatar
  • 2,183
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 ...
S G's user avatar
  • 3
0 votes
1 answer
544 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 ...
Mark's user avatar
  • 1
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 ...
BmyGuest's user avatar
  • 406
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 ...
Nys's user avatar
  • 11
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:...
FluidMechanics Potential Flows's user avatar
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 ...
robgaillard27's user avatar
1 vote
1 answer
68 views

Sort slicers data in excel

how can I sort data in slicers as shown in this photo
Mehmed Odeh's user avatar
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 ...
user697473's user avatar
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; ...
Christopher King's user avatar
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 ...
essay's user avatar
  • 103
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 ...
AyaanMAG's user avatar
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 ...
amymor's user avatar
  • 35
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 ...
RocketNuts's user avatar
  • 1,082

1
2 3 4 5
15