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

learn more… | top users | synonyms (1)

3
votes
1answer
52 views

Varying Format Part Number Sort Issue

(Current Sort Sample:) 2-1203-4 2-1206-3 2CM- 3-1610-1 3-999 … AR3021-A-7802 AR3021-A-7802-1 B43570- B43570-3 I am working on an 8000+ record parts list. The challenge I am running into is that ...
3
votes
1answer
37 views

Is it possible to change the 'Type' of a directory in Windows

Directories in Windows are always tagged as "File folder" in the explorer: Is it possible to edit this field? To introduce a new kind of folder? I would like to do that in order to enable another ...
3
votes
1answer
194 views

“Sort Lines” disabled in Sublime Text

I'm wondering why I can't click on Edit > Sort Lines in my Sublime Text 3 ? I often use it and I don't think I've done anything which could disable it, so I don't know where to search... What ...
3
votes
1answer
405 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, ...
3
votes
1answer
1k views

Sorting XML files so that differences can then be found

I need to compare two XML files, each of which is about 13,000 lines long. Sadly the code that generates these files doesn't generate the data in the same order each time (the data comes from a ...
2
votes
1answer
263 views

Is there a Unicode-aware LC_COLLATE sort order which respects punctuation?

As far as I can tell, setting the environment variable LC_COLLATE=en_US.utf8 changes four things compared to LC_COLLATE=c, regarding how programs like ls will sort files: Unicode characters are ...
2
votes
1answer
125 views

Tagging or defining automatically in an Excel or Libre office spreadsheet?

I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
2
votes
1answer
1k views

batch-rename filenames with numbers to sort alphabetically

I want to batch-rename files containing numbers, padding the numbers with zeroes. The goal is to sort numbered sets of files alphabetically in the correct order in any application. In a set of files ...
1
vote
1answer
266 views

Sorting by different currency symbols in Excel 2010

The Accounting Department enters receipts of money in different currencies ($, shekels, & Australian pounds). Is it possible to sort a column containing mixed currencies by currency type if the ...
1
vote
1answer
247 views

Change the sort order in Thunderbird on multiple columns

I would like to be able to sort (order by) email messages based on three (3) of the columns. Specifically at the top would be Starred, then Unread and then by Age (Newest at the top) (with Starred ...
1
vote
1answer
312 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 ...
1
vote
1answer
403 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 = ...
1
vote
1answer
441 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 ...
1
vote
1answer
294 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 ...
0
votes
1answer
7 views

Unix shell: Multi-level sort in opposite directions

I have a directory full of plain text files that have tags on the first line, and I want to get a list of the tags and their frequency. I've extracted the tags and sorted them into a big list; let's ...
0
votes
1answer
43 views

How to sort only selected desktop icons by name? (Windows 10)

I am running Windows 10, and I have many icons on my desktop. I would like to sort some of them (by name/date/etc), but when I Right click on my desktop and then do Sort By > Name all of the icons get ...
0
votes
1answer
67 views

Excel will not sort all columns on my worksheet

I have a very basic worksheet with multiple columns and rows. I usually will sort one column to sort a-z and normally all data for those rows would follow the sort. Suddenly I am finding that if I ...
0
votes
1answer
32 views

Sort excel table (multiple columns) by numeric column

I have this table from program profiling: I need to sort it by Total column. But instead, the Excel sorts the numbers alphabetically. I can't even believe it's that stupid. Just check it out! Of ...
2
votes
0answers
270 views

How to sort Google Drive search results by title?

I find Google Drive very convenient as an online notebook to store my diary and records, that I can access anytime, anywhere. Now when I want to search for a particular string of text, the only ...
1
vote
0answers
38 views

Sort list into tuples in Excel

Is there any way to sort a list into tuples as defined by a priority list in Excel? For example I would do a draw to get priorities: Banana -> 1 Apple -> 2 Tomato -> 3 And I have sheet of ...
1
vote
0answers
22 views

Microsoft Word: Sort Document Headings alphabetically

I have a document that contains Names syled in default Heading 1 and some normal Text below similar to. Busta Rhymes Trevor Tahiem Smith, Jr., better known by his stage name Busta Rhymes, is an ...
1
vote
0answers
73 views

Bash sort and join problems

I have to join two files. Firstly, I use commant sort and made two new sorted files. Next I use join, but it doesn't work. My script: sort -t ',' -r -k 4,4 file1.csv > sortf1.csv sort -t ',' -r ...
1
vote
0answers
89 views

Sort mails by 3 criteria on Thunderbird

I would like to sort my mails by 3 criteria, on this order : Date (new mails up the list) Read state (unread messages upper) "Starred" (starred messages at the uppest) But it seems that it is ...
1
vote
0answers
960 views

save folder sort setting in windows 7

I have Image folder and sort my image by date. Everytime I open a folder, windows sorts all file by name and then green bar fill address bar. after that all image sort by date. ...
1
vote
0answers
124 views

How to move starred and unread messages to top without destroying the order by date (descending)?

I'm trying to order my messages in my thunderbird inboxes and have multiple issues. I want to oder my mails like the following: Importent (starred) messages should always stay on top. Unread ...
1
vote
0answers
441 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. ...
1
vote
0answers
44 views

Reordering file lines like other file (Unix)

Is there a tool (or option for sort) which will re-order lines of a file so that they are ordered like a key in another file? For example, I have a data file: T01F01475558 30 T01F022B3A17 31 ...
1
vote
0answers
654 views

Path Finder: How to sort files by date, but folders by name?

This is possible in Total Commander. How can I make such separate sorting in Path Finder as well? I like to sort files by date, but I don't see any point in sorting folders this way - they just jump ...
1
vote
0answers
317 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", ...
0
votes
0answers
14 views

How to keep a value locked when filtering

I am trying to create a single list in excel containing a number of different groups. Within those groups I was hoping to lock some values into the order of their subset so that the order of each ...
0
votes
0answers
5 views

Retaining the order of a .bib-file when applying changes using Jabref

Short introduction to the problem: In my group, we work collaboratively on one single .bib file to keep all the references at one place. If one of the collaborators edits the .bib file, the order of ...
0
votes
0answers
48 views

Excel 2010 VBA AutoFilter and AutoFilter.Sort criterion not applying

I'm having a heck of a time getting AutoFilter criteria to apply, both the filtering and sorting. I'm trying to get rid of blank rows and filter over multiple criteria - simple, right? Except it ...
0
votes
0answers
28 views

Sorting large fixed-length record file

It is easy to sort a large (=does not fit in memory, fits on local filesystem) text file using GNU sort. When necessary, GNU sort will start doing external merges. How do I sort large files where ...
0
votes
0answers
38 views

Windows Explorer: custom order for sorting by type?

Is it possible to modify the exact order in which files are listed when sorted by type in Windows Explorer? Not just choosing between ascending/descending, but sort differently? For instance: 1. To ...
0
votes
0answers
39 views

Splitting .csv File Based on Values in Other .csv File

I have two .csv files. One contains a string in the first column, then a number per column for several columns after that, like so: ABU_1102;1162;1165;1167;1168 AFG_1220;1214;1215;1213;1212;1211 ...
0
votes
0answers
25 views

Windows Live Mail 2011 - Sort Sent Folder By “To” then “Sent”

My boss uses Windows Live Mail 2011 on his work PC for his non-work accounts. When he looks in his Sent Folder and sorts by "To" the emails appear to then sort by subject by default. This isn't ...
0
votes
0answers
10 views

Sorting Messages by date

I want to sort my messages from email which gets the application Phoneleash but I don't have idea how to do this. This is example massages: ➥telephone_number Message content--- [Sent: 16:43 ...
0
votes
0answers
11 views

adjust target cell in formula — target cell will change location when rows are sorted

I have a sum in cell B10. in C1 I want to show the value of B10, but rows 5-10 change each time the worksheet is used as a result of sorting. Is there any way to link the formula in C1 to a specific ...
0
votes
0answers
27 views

Pivot Table loses Custom Sort Order when saved

I have a Pivot Table in Excel 2010 on which I have sorted one column with a Custom List: Jan-2008 Feb-2008 [..] Nov-2025 Dec-2025 This works fine until I save the workbook. When I re-open the ...
0
votes
0answers
51 views

Fix inconsistent windows sorting (by name)

Here are some files that are sorted by name. The OS understands correctly that 2 should come before 10, great. But notice that The "new text document" come last, after "new text document2" even ...
0
votes
0answers
28 views

Can I add a custom sort order to Word 2013?

In previous versions of Word it was possible to add a new sort order...instead of the provided sorts for number, date, etc. you could add days of the week, months, etc. Is that possible in Word 2013? ...
0
votes
0answers
42 views

Kingsoft Spreadsheets = “Free” version of Excel…won't Sort by column Headers any more

I've had this happen even in Excel, but it's always annoying. I'll be sorting just fine, no worries, then boom, it will refuse to sort by the column Header and will only look at the first cell of data ...
0
votes
0answers
83 views

Sorting HTML content based on second line of table cell

I have an Windows text file, containing the text of an HTML table (no header, no footer) with each cell of the table not in alpha order. I'd like to alphabetize the tables, a la: REDACTED-TITLE-1 ...
0
votes
0answers
67 views

Spreadsheet Function Help - From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And There About

I have posted this question before, and got half-solution. Pls have a look at this link to get an idea. http://yogi--anand-consulting.blogspot.in/2014/11/yogifrom-table-of-names-and-birth-dates.html ...
0
votes
0answers
2k views

Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like: I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not). I have checked for ...
0
votes
0answers
125 views

why is my sort slower with more ram?

System specs below. I recently purchased 2X4 RAM: Corsair XMS3 8 GB (2 x 4GB) 1333 MHz PC3-10666 240-Pin DDR3 Memory Kit CMX8GX3M2A1333C9 I already had 2X2 in there for a total of 12GB: Corsair ...
0
votes
0answers
253 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
0answers
83 views

If sort created temporary files, does it mean it's out of RAM memory?

I was sorting a large file (101MB - about 700MB after unzipping) using sort command on server that has 48GB of memory. It was the only heavy job it was doing at that time. However I noticed that sort ...
0
votes
0answers
384 views

Excel 2013 - Is there a macro to sort and split the contents of a spreadsheet

I know there any many similar questions to this, but none seem to match exactly... I have a basic Stock List, and want to help to speed up stocktaking, so am looking to create a macro to do the below: ...
0
votes
0answers
464 views

Using VBA to sort cells to match the values in an adjacent column

What I would like to do is write a macro that sorts the values in the range B3:D9 on the left side of the linked image to produce the intended result (shown on the right side). For every value in ...