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

learn more… | top users | synonyms (1)

4
votes
1answer
86 views

Sorting data without mixing rows

I have three sheets. First sheet renamed General: Dave Henderson 21/05/2014 Elton Rus 22/06/2014 John Smith 20/05/2015 Second sheet renamed ...
3
votes
1answer
71 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
221 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
434 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
2k 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
465 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 ...
3
votes
0answers
317 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 ...
2
votes
0answers
114 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
25 views

How to sort by date modified ascending ALWAYS in Windows?

How to force Windows to sort always by date modified and always ascending? The situation is that often 1) Modified field is Off (not listed in Sort By menu by default) 2) Once opened More menu ...
1
vote
0answers
40 views

Any way to do Linux-style sort --merge in Windows PowerShell?

In PowerShell, if I have two files that are already sorted and want to merge them into one big sorted file, it seems wasteful and inefficient to do gc file1, file2 | sort-object > newfile, ...
1
vote
0answers
81 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
32 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
94 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
1k 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
137 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
503 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
45 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
677 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
319 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
4 views

Filtering filter/sorts in pivot tables

I created a pivot table with three columns. After filtering column 1, I would like the filters in column 2 to be adjusted by the column 1 filter. Is that possible?
0
votes
0answers
24 views

Group files by the specific day they were created on Windows 10

It would be very helpful to group files in Windows 10 file explorer by the specific day they were created. When someone tries Group By > Date Created in large icon view, they get useless, and vague ...
0
votes
0answers
24 views

In Excel, how would I sort by specific data

If I have a ROW of multiple reoccurring inputs (text), and I need to continually sort by only those specific names, is there a way in which I can automatically sort only by those names which I request?...
0
votes
0answers
29 views

How to sort filename duplicates numerically, with unnumbered filename first?

I have a list of files with the same name, but with numbers appended (see image). Like this: Target practice (01) Target practice (02) Target practice (03) Target practice How does one make ...
0
votes
0answers
13 views

Global columns playlist sorting script for Foobar2000?

I use Columns UI and Columns Playlist, and there is a sorting algorithm that is prioritizing artist name above all else, so it's messing up the track order and putting them in a 2,4,6,8,1,3,5,7 order. ...
0
votes
0answers
13 views

How to sort four columns with two diffrent values

I have four columns, I want to sort by the names and have the amounts also sort with the names. Can anyone please assist Column A Column B Column C Column D BOGOSI 55.00 BOGOSI ...
0
votes
0answers
9 views

Sort Outlook messages by subject without having to go to top in Outlook 2007

Outlook 2007 - When on a message, I want to click and sort by subject without always being forced to the top, i.e. subjects that start with A, rather I want to be able to stay on my current message ...
0
votes
0answers
12 views

Add tags on android pictures

How to add tags that could be seen on Linux system? When upload photos need automatic sorting by tags. Default tags on android doesn`t work.
0
votes
0answers
281 views

How to sort contacts alphabetically in Skype for Business

I am using Skype for Business. I observed that the list of contacts is sorted alphabetically, but by first name for some people and by family name for others, e.g.: Albert Einstein Doe, ...
0
votes
0answers
29 views

Sorting in Pivot Table

I have problem in pivot table with sorting field which is shown as difference between years 2016 and 2015. Excel 2013 make sort with original values and I want sorting by percentage difference. ...
0
votes
0answers
39 views

Sort Thunderbird emails by sender's domain

I want to sort/group my mails by sender's server/domain. Is that possible (plugin perhaps)? I'm aware that I can use find and search using "contains" in from field, but I'd rather wanted an ...
0
votes
0answers
19 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
20 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
156 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 doesn'...
0
votes
0answers
41 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
123 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
42 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
35 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
11 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 28.07....
0
votes
0answers
21 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
58 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
47 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
93 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
86 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
144 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
358 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
100 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
404 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
551 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 ...