Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
726
questions
0
votes
2
answers
166
views
Multi-level sorting in Excel
I have to run a report that has the data shown in the pictures. I need to sort it only by the R-A** (release) in column c then sort each release by assembly (column b). I can't sort it that way ...
0
votes
1
answer
1k
views
How to sort output of top command based on nice value?
We can use Shift+p to sort on basic of cpu usage, Shift+r to sort on basis of pid & Shift+m on basis of memory utilisation.
How to sort output of top command based on nice value?
0
votes
1
answer
732
views
Excel custom sort list works in Excel but not when file is transferred to SharePoint
I created a custom sort list of fiscal weeks that I use for my reports in Excel. For many reports I also use them as a Slicer. I have come across the issue where this custom sort list works perfectly ...
0
votes
0
answers
35
views
Custom excel sort/order?
So I've gone through a whole lot of sorting which isn't relevant to the question,
but for elaboration I'm getting 10 results out of 14. These results will be in order from 1-14 as I get them through ...
0
votes
1
answer
656
views
Which file system sort order is fastest in Windows 10 for large libraries?
Which file system sort order is fastest to load in Windows 10 for large libraries?
My intuition always told me that sorting by date modified was the fastest one to load up.
1
vote
1
answer
5k
views
Pivot Table: Sort row by hidden field
I have a table in Excel 2016 (source: Microsoft Query/ODBC):
Raw data:
Construction Type Location Sort
Reconstruction Main St - Red St to Blue St 1
...
0
votes
1
answer
2k
views
Linux `sort` doesn't work on numeric field
Here is a sample text file:
Peter:123777:ETA
Joan:16466:HLT
John:11223:HR
David:23456::::FSI
George::::876543:ECS
The task is to sort on second field, so I did the below:
cat input.txt | tr -...
1
vote
1
answer
594
views
Sort lines with "natural order" in Notepad++ like Windows Explorer?
Q: Is it possible to sort line with "natural order" (or what it calls, I'm not sure the correct name) like/similar to Windows Explorer? With or without plugin are fine
Demo lines:
text 1
...
0
votes
1
answer
19
views
Automatically send certain filetypes to preset location
So the workflow I'm going for is saving the active webpage as .MHTML using a keystroke and make it go into a pre-set save location, so there's no interruption to browsing. I can easily get the .MHTML ...
0
votes
2
answers
1k
views
Excel Sort Command not working AT ALL as expected
I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways:
the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
0
votes
2
answers
73
views
Sorting Function in sheets or excel
How do I do a repeated function in excel?
I want the pattern to go: (Vertical)
=a1
=b1
=c1
=a2
=b2
=c2
=a3
=b3
=c3
and so on. this will go on for until:
=a400
=b400
=c400
Example in sheets
0
votes
0
answers
2k
views
Display folders first in File Explorer search
Whenever I search for something (in this case "*") in File Explorer, folders appear mixed in with files:
Is there a way to make it display all folders at the top like it does outside of ...
0
votes
2
answers
596
views
Sorting Excel tables by localized alphabetical order
The English Excel (improperly) sorts the following strings as follows:
SARKIN
ŞENER
SEZER
ŞİMŞEK
SÜRMELİ
However, these are all Turkish strings where S and Ş are strictly different letters and Ş ...
0
votes
1
answer
27
views
Applying View Options to Uploads
(First post here, so forgive me if I get anything wrong.)
I'm an artist, so I have a lot of image folders, and a lot of images in those folders. I order them by date to avoid confusion, but whenever I ...
3
votes
3
answers
781
views
Sort chemical elements such as H, He, Li, Be by atomic number in Excel
I have a long table with columns for sample, analysis number, test method, etc. and, importantly, the chemical element that was analyzed.
I would like to sort my table by sample first, then by ...