Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
726
questions
0
votes
0
answers
44
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
- 1
0
votes
1
answer
52
views
Windows sort folders differently now, and I would like the old behavior
Windows used to always show the subdirectories (aka folders) first, regardless of sort order. It seems that several years ago, this was changed. I would like the original behavior where folders are ...
- 1,989
0
votes
1
answer
29
views
MS Outlook Sortable User-defined Columns
In response to the question "How do I get rid of the "External" label in Outlook?", user Lilienthal posted a response on Jan 20, 2023 by creating a custom column using the formula ...
- 1
1
vote
3
answers
173
views
How do I sort an Excel sheet vertically = reverse the order of the full sheet = put the sheet bottom up = turn the worksheet upside down?
Data in an Excel sheet needs to be sorted the other way round. I cannot sort the data by the two columns date and time since there are some lines in it that do not have the same pattern, for example ...
- 2,423
1
vote
1
answer
83
views
Excel sort numbers smallest to largest with cells that contain multiple numbers with "/" or "," between numbers
I have a column of numbers
I want to sort the list smallest to largest numbers, but any number with a "/" or "," will be put at the end.
How can I sort from smallest to largest ...
- 203
0
votes
2
answers
94
views
Why some cells can not be sorted in Excel
I am met with very strange things with spreadsheets in Excel now. Some cells with a date like 2023-10-22 can not be sorted with other cells in the same format in a column. I changed the format of the ...
- 397
1
vote
2
answers
72
views
How can I sort my file by date if there are different number of spaces between the name and date?
How can I sort my file by date if there are different number of spaces between the name and date?
My example file:
Ivanov 03/01/1980
Petrov 10/05/1992
Sidorov 21/07/1985
Kovtun 15/...
- 21
-1
votes
1
answer
75
views
Sorting grouped cells in excel based on one column with alpha and numerical values
So my original dataset is structured such that each row represents one street and then there are three sets of columns that represent a recommendation for a design feature to change (like add trees), ...
- 1
1
vote
1
answer
64
views
Put numbers in Ascending order then label them (highest to lowest) 1,2,3 etc in next cell
I have a small list of numbers in no particular order in a column
900
465
650
1125
800
1212
545
in the cell next to each I want to show were each number comes in ascending order 1,2,3 etc (highest to ...
- 23
0
votes
0
answers
69
views
Sort by none/disable auto-arrange in Explorer doesn't exist or does not work
Unchecking Sort By "Name" seems to be disabled. Is there any way around this?
This is EXTREMELY limiting and frustrating in Windows 10, in fact, anything past Vista. No matter what I do to ...
- 1
0
votes
1
answer
169
views
Is it possible to have mulitple inboxes in Thunderbird as in GMail?
I would like to have a feature similar to what I currently use in GMail:
one inbox with all unread email;
one inbox with all starred email;
one inbox with everything else.
Note that all these ...
- 230
2
votes
1
answer
92
views
Sorting a Wikipedia table by numerical value in a text document?
I've been working on a 3474 line table. Getting the information was easy, capturing the needed information from public online sources. But I came across a problem.
The table is by default sorted ...
- 23
0
votes
1
answer
108
views
How to create a sorted table summary of the count of a categorical column in Excel?
I have a dataset like:
Animal fruit
cat apple
dog grape
cat cherry
cat pear
dog cherry
horse melon
cat lemon
I would like to create a summary table counting each occurance ...
- 103
0
votes
2
answers
310
views
Sorting each group of data based on the values on a column in Excel
My data is look like,
As you can see, I used the label column in order to group my data and rows with the same label belongs to the same group in this way. Now I want to sort each group based on data ...
- 121
0
votes
1
answer
70
views
bash sort by numeric substring
In bash shell I'm trying to sort by a numeric value at the end of each line (sort by number of packets)
Tried to use "sort -k6 -t '=' -n but not working.
Input:
type udp ip src=192.168.2.173 ...
- 15