Questions tagged [sorting]

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

199 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
1 answer
805 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
user265560's user avatar
1 vote
0 answers
844 views

Music Library Sorting Issue

I'm using WMP for for managing my music library. Lately I noticed something. I was reorganizing my library and came across a strange -I mean annoying- behavior of WMP. The way WMP sorts Artists. ...
akinuri's user avatar
  • 449
1 vote
1 answer
830 views

Office 2007: How to sort an Excel Table from within a Word macro

I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines: Dim Oxl_Sheet As Object Set Oxl_Sheet = ...
Marcel's user avatar
  • 23
1 vote
1 answer
2k views

Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature. These cells are colored differently, but the height doesn't stick with the ...
Excellist's user avatar
1 vote
2 answers
155 views

sort numbers in excel10

this is a sample of my movie list as you can see 61 is at the top and 8mm at the bottom please explain how i can have 1 at the top and 3000 at bottom 61 .45 2006 dvd 10 1979 dvd 10 items or less 2006 ...
exmarine's user avatar
1 vote
1 answer
342 views

How do I re-sort a list of files grouped by directory?

From within a DOS batch file, how can I crudely re-sort a text file containing a manually maintained list of source files, so those files listed (from the same directory) in the small example extract ...
Colin's user avatar
  • 11
1 vote
2 answers
92 views

When your field-terminating char appears within field values

I've had a very colorful morning learning the innerparts of Linux's sort command, and have come across yet another issue that I can't seem to find an answer for in the documentation. I'm currently ...
Sampson's user avatar
  • 7,368
1 vote
0 answers
360 views

Sorting in Pivot Table on how data is summarized, not just the value

Often I am creating pivot tables that summarize some count by some category. Let's say I am counting Yes/No responses by some category. I usually add the count field and display it as a "% of row", ...
mindless.panda's user avatar
1 vote
1 answer
3k views

outlook 2016 how to disable the new "Newest on top" feature

As part of the latest updates to Office/Outlook 2016, suddenly the section above the messages list got "weird" in its layout. The best way to understand what I'm trying to describe here is to look at ...
TheCuBeMan's user avatar
  • 1,059
0 votes
0 answers
31 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
80 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
286 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
0 votes
0 answers
69 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
  • 766
0 votes
0 answers
782 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
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,423
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
367 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
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
128 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
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
0 votes
1 answer
167 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
153 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
297 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
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
27 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
844 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
79 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
0 votes
0 answers
2k views

How to sort dates in ascending order in pivot table by month

I am trying to get a pivot table data set to sort dates in ascending order. The first step I took was to ensure the year was populated first. So, this is sorted by the year. However, the months are ...
user1530279's user avatar
0 votes
3 answers
2k views

Windows Powershell: Get Items from directory -> md5 them -> sort list by filename -> out to file

Is there the way to complete mimic this unux command entirely by Windows Poweshell means, not with using the WSL: find ./<dir1>/ -type f -exec md5sum {} + | sort -k 2 > dir1_hashes.md I ...
Harley Frey's user avatar
0 votes
1 answer
412 views

Keeping two rows together when sorting

I would like to know how to link specific rows when sorting a table in excel. I have already made the table and in each row contains data for a specific person. Each person has two rows. My boss would ...
austin yarnell's user avatar
0 votes
2 answers
144 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 ...
Stacy's user avatar
  • 1
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?
Udesh's user avatar
  • 882
0 votes
1 answer
613 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 ...
JGO's user avatar
  • 3
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 ...
OfficeMoose's user avatar
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 ...
TickleMeTimbers's user avatar
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 ...
gargoylebident's user avatar
0 votes
2 answers
525 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 Ş ...
Utkan Gezer's user avatar
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 ...
oggser's user avatar
  • 1
0 votes
0 answers
60 views

Platform/version-independent sorting for gnu sort

I am trying to do an offline comparison of two lists generated on two different systems. They both have GNU coreutils so to aid the diff'ing, I sort both lists using sort before transferring them. I'...
dovetalk's user avatar
  • 233
0 votes
1 answer
733 views

how can sort my files in windows with custom filter?

I have roughly 80 files in that files all files have # number like (in file name's last portion has #1,#2,#3 like) I want to sort this with # order how can I do that. Please see image for more ...
Jp Ways's user avatar
0 votes
0 answers
37 views

sort games in their subfolders

Recently I started using Batocera, and I am collecting games. I found on my drive tons of amiga games, which in most cases are in multiple files e.g. samurai1.adf samurai2.adf Battleships.adf exile - ...
Mikołaj Zdanowicz's user avatar
0 votes
1 answer
484 views

Sort LibreOffice Calc rows through all columns

I have a list of items with set of properties. Some of the properties are unique, some are the same. I want to sort the properties through all items to see which items have equal properties. Maybe it'...
Const's user avatar
  • 1
0 votes
2 answers
385 views

How do you sort Paired Data on Spreadsheet?

How do i sort my data to produce a sorted paired row + sorted position outcome? Desired Outcome: Row Position R1 A01 R2 A01 R1 A02 R2 A02 R1 A03 R2 A03 R3 A01 R4 A01 R3 A02 R4 A02 R3 A03 ...
Excel noob's user avatar
0 votes
1 answer
267 views

How to sort values in a column depending on values on different columns?

I have a large table in which I want to sort as follows: Sort by column F If a value in column F is between 5000 and 6000, sort these rows by values in column B If a value in column F is between 6000 ...
MarioF's user avatar
  • 1
0 votes
0 answers
433 views

Sort folders by custom value in Windows 10

I am currently cataloguing a large amount of family photos and I have gotten to a point where I would need to sort a lot of folders by a custom value. From what I gathered on the internet, Windows ...
Inner City Blues's user avatar
0 votes
0 answers
2k views

"Date modified" of downloaded file is in the past - Windows 10

I like to order most of my folders by "date modified". But sometimes I will download a file with a timestamp in the past. This is very disruptive to me (I have to check chrome downloads to ...
Gappy Hilmore's user avatar
0 votes
0 answers
46 views

Matching 2 Data Set rows with similar column headings

I have 2 data sets A-Q (left) and U-AA (right) I am trying to match the rows on the (right) U-AA with the rows on the (left) A-Q Once a record on the right matches the first like record to the left ...
Matthew Lazarus's user avatar
0 votes
1 answer
126 views

PDF-Pages To PNG And Back To PDF In A Hotfolder Via Script

For security-reasons I want to decompose PDF-files and put them back together (like printing them and scanning them back in). I want to offer this for my users, so I would like to script a kind of ...
OneFineAdmin's user avatar
0 votes
1 answer
627 views

How to replicate windows name sorting in linux?

I need to print a list of files to a text document in the same order they show in the windows explorer alphabetic sort, but I can't find any method of sorting with ls | sort that shows the exact same ...
metichi's user avatar
  • 101
0 votes
2 answers
2k views

sorting dates and time (in text form) in Excel

My date and time entries in my excel file are written in the form of: Feb 18 at 3:50pm. All of this is in one cell. I was wondering if there is a way to sort this out (arrange chronologically)
cgo's user avatar
  • 121