Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
3k views

How do i align multiple columns in excel by name and sales?

Please ref attached image. I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third ...
2
votes
2answers
15k views

Not able to sort columns

I have a pivot table and I would like to sort some columns. But the "sort" function is not working at all. When I click "sort from A to Z" nothing happens. I am just able to sort the first column of ...
5
votes
4answers
63k views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...
0
votes
0answers
24 views

Collect Group Members & Administrator from different group on AD (Powershell)

I need your help about a powershell script & I’m a newbie on Powershell. I have to collect members & administrators of different groups from AD, in .CSv format. I have a specific way for that ...
0
votes
4answers
11k 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
2answers
51 views

How to sort files in Windows explorer in custom order?

I have a great deal of folders. Each contains more than 30 files. I’d like to sort these files in a custom order. How do I create a custom order and have it sorted out the files the way I want? I was ...
0
votes
0answers
23 views

How to fix sorting

I'm afraid to describe my problem properly, because last time I did it became falsely marked as a dupliccate and there is no answer to my problem yet. So: This is the sorting I want I don't want it ...
0
votes
0answers
12 views

Windows Explorer sorts files wrong/ in a different way than folders [duplicate]

The Windows Explorer sorts my files in a rather "interesting" way when I want them to be sorted by name. They are sorted like this: VRU3 Mitschrift VRU3.2 Mitschrift VRU3.2 VRU3 Instead of ...
9
votes
3answers
15k views

Sort order in Windows Explorer

The behaviour described below occurs on Windows-7 systems and on Windows XP. We operate in a dual-language environment - English and Hebrew. When in Windows Explorer we sort files by name, the order ...
2
votes
3answers
2k views

how to reverse the sort order of tabs in firefox?

I need to print (to PDF) a large number (about 80) of tabs all at once, but in a specific order. The problem is that the tabs all got opened in the reverse order of what I want. Dragging them around ...
1
vote
1answer
300 views

Sorting in outlook by flag - change sort order

I would like to make outlook to sort my messages in a certain search folder by the following order: First - sort by flag status in the following order: followup flag first, unflagged second, completed ...
2
votes
1answer
3k 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 ...
0
votes
0answers
10 views

In Tableau, when using “Sort By” Field option using a parameter, how can the aggregations (average and sum) be changed as the parameter changes?

I am trying to sort a colored stacked bar chart in my view. I created a "Sort By Dimension" parameter in which I can choose which field I want to sort by. There can be two selections here. ...
0
votes
0answers
37 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 ...
10
votes
6answers
9k views

How to sort images into folders, based on resolution?

Background: I've got a folder full of saved desktop pictures. I'd like to put them into folders, based on their resolution - 1024x768, etc. Creating the folders on the fly is a bonus. Currently, the ...
0
votes
0answers
25 views

How to sort a list on Excel by letter first rather than the number, even if the cell value starts with a number?

Is there a way to sort a list by the first LETTER of a cell rather than the first NUMBER. I need to sort a list of addresses by the street name not by the street number so I can see the multiple ...
0
votes
1answer
36 views

Excel is not sorting letter correctly

I have a weird problem with Excel: it is sorting the letter "CH" incorrectly (it places "CH" after "CZ"). As you can see in the attached image, it only happens with "...
0
votes
0answers
40 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 ...
1
vote
2answers
33 views

How to change the default sort order in Windows Open window?

How to change the default sort order in Windows Open window? Example: Paint => File => Open => /* need to order by date by default */.
0
votes
0answers
22 views

Find recently modified files of a specific type in Windows 10

I'm looking for a file which I don't remember the file name and path but do remember the file type. Can I see all files of a specific type in all directories in the order of last modified time?
0
votes
0answers
11 views

Pivot Custom Listing (unable to save)

I have created a custom list for Pivot by going to <Options, Advanced, Custom list> method. However when I close the excel file and reopen it, the custom list goes away. Any way out to save the ...
0
votes
1answer
25 views

Post-processing of multi-column CSV: remove dublicate lines + sort

I am dealing with the csv produced by the concatenation (via cat) of several CSVs: ID(Prot), ID(lig), ID(cluster), dG(rescored), dG(before), POP(before) 1000, lig40, 1, 0.805136, -5....
7
votes
11answers
170k views

Excel Sort Numeric Column By Number

I have a column of integers in my spreadsheet, and the column is formatted as a number. Each cell inside the column is formatted as a number. But I can't seem to sort them in numerical order - you ...
0
votes
1answer
25 views

Sorting lines according a column value

I need to sort all of the linnes in the csv filles according to the number contained in the second column from min to max, ignoring the first (header line): ID(Prot), ID(lig), ID(cluster), dG(...
0
votes
0answers
43 views

Inputting data into a sorting table in Excel

For my project I need to design a warehouse, in which I sort the products based on the amount of times it is requested, with the most requested product going to the location with the shortest travel ...
3
votes
1answer
222 views

Sorting fomulas in an Excel table

For my project I need to arrange locations based on the lowest driving time to different locations. I simulated the driving distances (Row D, E & F), but the height depends on the products which ...
0
votes
1answer
28 views

In LibreOffice Calc, why would sort buttons and menu items suddenly become disabled?

I was creating a spreadsheet in LibreOffice Calc. Several times, I used the "Sort Ascending" and "Sort Descending" toolbar buttons. All was well, and everything was working as ...
0
votes
2answers
3k views

Sorting Dates in Excel

I have dates in an excel spreadsheet I need to sort. They are formatted as month and day, ex: 9/12. I want to be able to sort so that all months and days are in sequence starting 1/1 to 12/31. How ...
0
votes
0answers
29 views

Sort Bullet list alphabetically, maintaining formatting in Notepad++

Hello I am trying to sort lists alphabetically that contain entries separated by • and I need it to maintain formatting. I am using Notepad++ and can also use Python Script (Plugin). Example source: |[...
0
votes
1answer
15 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 ...
0
votes
0answers
10 views

Trying to summarise multiple lines of data by latest date (LinkedIN Export)

I want to create a list which shows the latest date that someone sent me a message on Linked In. I have exported the data, in the following format, and there are multiple entries for individuals who ...
4
votes
3answers
29k views

How to order a numbered list in descending order?

When using a numbered list in Word, how can I have it order in descending order (ie. 10., 9., 8., 7., ...) ?
1
vote
1answer
61 views

Sort all files in subfolders by type

So I have a folder with several subfolders containing photos and videos (mainly but not exclusively, .jpg and .mp4 respectively). I want all files in every subfolder (of the folder in question, NOT ...
5
votes
5answers
9k views

How to sort list-style numbers in Excel?

I have a column of "numbers" in Excel that I would like to sort as follows: 1.1 1.2 1.2.1 1.2.6 1.2.9 1.2.10 1.2.11 1.3 However, regardless if the cell's type is number or text, Excel sorts them as ...
1
vote
1answer
51 views

What does # mean in Windows Explorer column?

What does # mean in the Windows Explorer column? I've never seen something written in that column.
0
votes
1answer
48 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 ...
0
votes
0answers
50 views

Group rows in excel based on cell criteria, then sort data by a different criteria without losing the grouping

I am struggling to group cells together in excel and sort by a different criteria. I work for a telco company and look at repeat trouble tickets. I would like to group the rows together based on ...
0
votes
1answer
14 views

Sorting a text file based on data before the first comma

I have the following text file that contains rows in a format of [Number,IP address] and want to sort it based on the number portion. I tried using the command sort -r -k 1 -t"," Input.txt &...
3
votes
1answer
178 views

MS Excel 365 Not Sorting

I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does ...
1
vote
2answers
20 views

How may I sort strings with more than one pre-requirement?

I have bunch of strings (around ~300) and they are all 4 letter such as XYZA, ZHF3, RTt2 etc. I want to sort them depending on the 2 requirement. Sort them in order of last 2 letters Sort the words ...
7
votes
2answers
1k views

In which order does Windows Explorer sort folders when sorting the results of the search by size?

The files are sorted by size but not the folders, so I wonder how Windows Explorer decides the ordering of folders when displaying them. I use Windows 7 SP1 x64 Ultimate. Example of sort by size:
2
votes
1answer
5k views

Sort by number at the end of the file name in Windows Explorer

I want to know how can I sort my files in Windows Explorer using the last two digits in the file name. I have the following files in my folder: f00001.jpg f00002.jpg f00003.jpg b00001.jpg b00002.jpg ...
0
votes
2answers
56 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)
-1
votes
2answers
40 views

Sort by 2 different conditions windows detail view

Is it possible to sort by both name and date in windows detail view? First sort by name so that I can see the range of product I want and then by date in order to get the latest version of the product?...
0
votes
1answer
68 views

Default files sort order used by “dir” command / core Windows 10

tl;dr I cannot replicate sort order used by dir command in Windows 10, neither within File Explorer nor Total Commander. I have tried to change sort order based on many different columns and still ...
0
votes
0answers
15 views

Ordering files alphabetically is not respected in Windows Explorer [duplicate]

I've a folder with a file list. All files have the same root name but change in order on its refere date, as follow: This is my wished alfabetically order: MyName - 202003.pdf MyName - 202006.pdf ...
0
votes
1answer
17 views

How to sort network devices with VLANs by numeric order

I'm trying to create a neat and tidy motd for some embedded devices that will have multiple NICs and VLANs. Here's a sample output: Networking sent recv tx-err rx-err address enp7s0 UP 66K ...
2
votes
1answer
96 views

Sort and change index numbers in Notepad++

I have some files that start with an index number similar to this: (1) etc (2) etc (3) etc I want to add lines between and make Notepad++ to change index numbers automatically. So for example if I ...
19
votes
4answers
30k views

Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...
1
vote
1answer
26 views

Counting and sorting a cell in excel

I need help to sort out a list of agencies. I have now gotten the frequency for each agency but I need them to match. Then, I need to sort out this list from Largest to Smallest frequency. That means ...

1
2 3 4 5
13