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

learn more… | top users | synonyms (1)

0
votes
1answer
20 views

Sorting rows while maintaining column values across sheets? [on hold]

So the system I have setup for timesheets for people in the company is ProjectSheet.xls : A B 1 **CODES** **PROJECT** 2 A202.1 Alpha 3 A203.1 Beta 4 A402.1 Gamma ...
0
votes
3answers
291 views

Using Excel and Sorting Data

I have a spreadsheet with over 1500 rows and 20 columns, in column C I have manufacturer as my header and below it 1500 listed names, one for each row. How do I extract the names into a single ...
0
votes
1answer
21 views

How to Sort a Pivot Table based on two columns of information

I work in the Auto Industry where I have to create a Pivot Table based on Auto information each month. The Sort Order of the Pivot Table needs to be Model Series Door Cylinder Model ID Code Trim ...
0
votes
1answer
24 views

Excel doesn't sort columns to the right of a blank column

If you try to sort on a column when there is a blank column in the spreadsheet, only the columns to the left of the blank column will be sorted. How can this be changed so that all columns are sorted ...
1
vote
2answers
35 views

Sort Excel Pivot Table by Percentage of Count

I have source data showing timesheet approvals in the following format (for about 850 employees and 200 managers): Employee Name Manager Name TS Approved? Employee 1 Manager 1 No ...
0
votes
0answers
6 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
1answer
23 views

How to sort a column (Y) for each group in column (X) in excel 2013

Is it possible to sort a column (Y) for each group in column (X) such that even values in column (Z) are changed? I have about 23000 rows so manual sorting for each group is difficult. I have attached ...
-1
votes
0answers
10 views

Excel 2007 - Sorting data

I have a spreadsheet set up with products down the left and months & values in columns next to each other across the top, this spread sheets is complete but I am unable to sort the data as I need ...
1
vote
3answers
34 views

Sort by `ls -l` Dates Without Using `ls`

I have a text file with a bunch of ls -l output, such as: -rw-r--r-- 1 root root 7554952082 Dec 15 22:11 /var/spool/stuff/Investigation/messages.tgz -rw-r--r-- 1 root root 4315 Mar 3 2015 ...
0
votes
1answer
50 views

Excel - Sort by formula when there are duplicate values

My data will change, therefore I am using dynamic lists. Sorting needs to be dynamic as well. I do not want to click on the built in sort function. I'm sorting dynamic data by formula, but it fails ...
0
votes
0answers
8 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
1answer
31 views

Windows 7 or 10: Explorer Sort Order - distinguish between normal Explorer vs. Open-File/Browser windows

Is there a way to make Windows (7,8,10,whatever) remember a different sort-order for displaying your files in regular Explorer windows vs. open-file/file-browser dialog windows? To give an example. ...
0
votes
2answers
34 views

Excel sorted heading won't sort data in whole spreadsheet

So I would like to be able sort all my data using the little drop down arrow created by the filter function, all the way from F to JE. At the moment it will only sort from F to AK. Any idea how I ...
0
votes
2answers
28 views

How can I sort Excel cells in groups?

I have something like the following, but over 1000 rows. Further down some of the blue headers have multiple white inner cells. Now I know I can do grouping, but if I select row 1 and 2 and group ...
0
votes
1answer
35 views

Sort files and folders in the same way in Windows Explorer - sorted by names [duplicate]

I just want to see files and folders (sorted/grouped by their name) in a list that does NOT separate files and folders. I also don't want to order by date modified like here. I already tried several ...
-3
votes
1answer
40 views

Deleting multiple rows selectively from Excel 2010 [closed]

I have 19,000 datapoints in each row, now my problem is how to delete 20 rows simultaneously after an interval of 10 rows?
0
votes
2answers
54 views

Sorting Data in Microsoft Excel

I have an Excel sheet that I use to keep my user's information. This is a huge file and I have multiple rows and multiple columns per username. I am trying to sort the user names alphabetically ...
0
votes
1answer
38 views

How do I sort files by date in filename?

I have a set of filenames like this vorlesung 02.11.15.mp4 vorlesung 04.01.16.mp4 vorlesung 07.12.15.mp4 vorlesung 09.11.15.mp4 vorlesung 09.12.15.mp4 ... The last part of the file name is a date ...
0
votes
0answers
72 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
20 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
17 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
1answer
36 views

Thunderbird thread view - sort by star then date

So far I've been sorting my emails in non-threaded view, by star, then by date. Understand, first all starred message (sorted by date) then non-starred message (also sorted by date) Either this ...
0
votes
0answers
16 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 ...
2
votes
2answers
237 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
32 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
13 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
7 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
202 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
19 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
96 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
88 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
86 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
32 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
169 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
69 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
67 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
81 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
25 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
32 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
44 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
73 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
145 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
59 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
26 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
26 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
60 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
30 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
80 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
46 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 ...