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

learn more… | top users | synonyms (1)

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 ...
1
vote
2answers
31 views

How to disable automatic sorting in Windows 10?

I want to be able to arrange files in the file explorer in a certain order. Is there a way to disable the automatic sorting feature for folders? It is possible to disable automatic sorting on the ...
3
votes
1answer
16 views

Sorting Excel Rows & Columns into descending order of activity

I have a spreadsheet with 45 rows and 85 columns. Not all 85 columns contain information. Some rows will fill all 85 columns, some rows only fill 40 or 50 columns. Is it possible to sort the ...
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
0answers
9 views

How to sort spreadsheet by date+time column but with a modified hour column? [migrated]

I have a spreadsheet generated by a google webform and it produces a standard spreadsheet with a full timestamp column that is two hours behind and a hour column (hh:mm am/pm) that the user fills in ...
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
1answer
45 views

Cannot sort Excel Pivot Table by two or more columns

I want to sort my Pivot Table by two columns. I've searched the web for some time, and it seems Excel doesn't allow this, so I need a workaround. My data Desired Outcome I want to summarise this ...
1
vote
1answer
18 views

Sorting a comma separated file by the first column while preserving some order

I have a file of the form: kl2,LL kl2,nan kl2,MORE kl2,PRQ kl2,JJ abc87,PRQ abc87,JJ abc87,nan abc87,MORE abc87,LL ... and I would like to sort this by the first column, while leaving the second ...
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 ...
4
votes
2answers
63 views

Is there an add-on for Excel to allow me to sort by an arbitrary column with a SINGLE click?

Windows Explorer allows you to sort by an column by clicking on the 'header' of that column so you can see files sorted by size or filename etc. Excel on the other hand forces you to go through the ...
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 ...
1
vote
4answers
27 views

UNIX Command to sort file based on word delimited

I have a file that has lines file.txt like this: www.site.com/230207|Sophie Rundle title: Episodes|5irko3ke www.site.com/228264|Camilla Luddington title: Balifornication|5423234 ...
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 ...
-1
votes
1answer
30 views

Text Data not sorting as desired

ESXi 5.0.0 ESXi 5.0.0 ESXi 5.0.0 ESXi 5.0.0 ESXi 5.0.0 ESXi 5.5.0 ESXi 5.5.0 ESXi 5.5.0 EXSi 4.0.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 4.1.0 EXSi 5.0.0 EXSi 5.0.0 EXSi 5.0.0 ...
0
votes
1answer
37 views

Excel: Copy all cell values from an entire sheet to a new sheet, sort and deduplicate into a single list of unique values

The data (all text values) I have is scattered across the sheet (multiple rows and columns with gaps inbetween) and it is all calculated using formulas now I would like to make sure that I know what ...
2
votes
2answers
49 views

Unix vs Excel sort

I have the following list of files sorted according to Excel: a1.txt a10.txt a11.txt a12.txt a2.txt If I use sort on Unix/Linux, I get the following order: a10.txt a11.txt a12.txt a1.txt a2.txt ...
1
vote
1answer
36 views

Firefox sort history based on time

Sadly it only seems possible to sort history on date After collecting all sites of today (way too many) Firefox orders the history alphabetically. I want to sort only on time and date. Like with ...
0
votes
1answer
23 views

open files in sorted order (OSX)

I'm looking for a terminal command to open many files in preview in "sorted" order. I'd like to open the files in order: 1.pdf, 2.pdf, 3.pdf, 4.pdf, etc. But without first sorting, they are opened ...
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
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 ...
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 ...
-1
votes
1answer
77 views

Excel auto sort rows?

I know how to sort rows given their value, however as I keep adding new rows the values keep changing and I would like Excel to auto sort every thing I add something. On sheet 1 I have a table like ...
1
vote
0answers
40 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 ...
0
votes
2answers
24 views

How to sort text file by labeled field?

I have file with line format as follows: <something> <file_name> type:file <something> size:<filesize> <something> I would like to sort numerically it by the field ...
0
votes
1answer
19 views

How to mass format window files sorting and view style for my entire computer?

When going into a folder of a window, I usually do 1) right click > view > list, then 2) right click > sort by > type. It gets annoying when I have to do this every time I am in a new folder, and ...
0
votes
1answer
35 views

mc - Midnight commander - How do I sort so that directories are on top?

By default, mc sorts so that the directories are on top (come before files). Somehow, I've changed this so that the directories are sorted alphabetically. Where is the option or keyboard shortcut to ...
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 ...
0
votes
1answer
47 views

excel: how to place rows at the bottom of list in sort and filter options?

Here is what I have at the moment: Click on home ribbon button click sort & filter drop down box I have a sort option as follows: As you can see the rows have been commanded to go to the top ...
2
votes
1answer
28 views

How can I make unix sort work properly using the underscore as a field separator?

When I sort foo and foo1, I expect foo to come first, which is what happens ordinarily with unix sort. $ echo -e "foo1\nfoo" | sort foo foo1 But when I add and underscore and use the -t and -k ...
0
votes
0answers
40 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
1answer
15 views

Sorting using Subtotals and Data Subtotals

In sorting using Subtotals via Data Subtotals, is there a way I can get all lines of info to come down NOT just the ones I'm totaling? The only way I have remedied it is copying it down from the Page ...
1
vote
1answer
94 views

Excel Sort and Lookup Values Formula

I am trying to create some sort formulas on excel. An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...
-3
votes
1answer
91 views

How to sort cell phone numbers by carrier in excel?

Please help, I've been trying to figure out how to sort cell phone numbers by carrier. For example, the cell contains 9132345434 and if the first three digits are 913, 932 or 917, it will say in ...
-2
votes
1answer
47 views

Join some files in bash

I have a task. I have to join files A:B.dsv, B:D.dsv and N:A.dsv. Column are separated by ':'. And I have to join by relation N:D. And sort end file by D. A:B.dsv: R0X 7M3:48B56 L6R 5X3:08P68 E1W ...
0
votes
1answer
25 views

join - file is on sorted

I tried join two files, but I don't know why join doesn't listen to me. File i: 1 afjsadfjasdf 3 afdadsfa 4 afjdsakjfads 5 asdfadsfads 9 asfadsfads File k: 1 fdasdfadsfads 2 dfasjfadsjfas 3 ...
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 ...
0
votes
1answer
62 views

Sort file by two column in the event of two the same value

I want to sort files by one column, but in the event of two the same value I want to sort these two by other column. How can I do it? My file: 1 2 3 1 3 2 1 4 3 2 4 1 2 1 3 3 1 ...
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 ...
1
vote
1answer
54 views

Windows Explorer - Treating cameras/Android file systems like disks and sort by date

My Android current, and previous, Samsung phones identify as a camera (technically a media device) to Windows. They do this because they have internal flash and to mount the file system to another ...
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 ...
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
2answers
59 views

Ordering of filenames in linux - not purely lexicographical?

Given a few files in a directory data the following ls command provides a surprising result in the sense of how they are ordered: for f in data/*; do echo $f; done ...
0
votes
1answer
71 views

Sorting in SSRS 2008

I am trying to sort a column from largest value to smallest in SSRS 2008. These values are derived from an expression, not an actual data field. So I am wondering if there is a way to sort this ...
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 ...
1
vote
2answers
64 views

Sorting rows in Excel 2013 based on when they were added [closed]

Is there a way to sort rows in Excel 2013 based on when the rows were added?
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 ...
3
votes
1answer
178 views

How to sort the output of find? [duplicate]

I'm using the find command to list files with their name containing a string: find ~/ -type f -name "*inductive*" I would like to use a pipe to sort the resulting list of files. I would like to be ...
1
vote
1answer
268 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 ...