All Questions
Tagged with microsoft-excel sorting
246
questions
0
votes
0
answers
43
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
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,425
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
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
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
0
answers
911
views
Excel: How to best sort/match two (+) columns with a different amount of rows?
Hello I am trying to figure out a few different ways to accomplish this, to find the most efficient approach. Any and all help appreciated.
Here is one workaround I found but cum er some and does not ...
jds00
0
votes
0
answers
27
views
Sort information in Excel displayed in "cards" [duplicate]
I'm looking to create data "cards" in Excel which is a way to visually display information next to an image:
The reason to display information this way is because I want to always be able ...
- 103
0
votes
0
answers
3k
views
In an Excel PivotTable, how can I sort by multiple row fields?
In Excel PivotTables, it's easy to sort, say, the rows by the major row field: There's a "Row Labels" column with a menubutton on the side, you click it, and you get sort options, just like ...
- 9,761
0
votes
0
answers
37
views
Sort text and numbers in Excel so the numbers sort properly?
I've created an inventory of my watercolor paints. Paints use pigment categories and pigment numbers. For example, blue pigments all start with the pigment category PB (pigment blue), followed by the ...
1
vote
2
answers
1k
views
Correctly sort semantic version list using Excel
We use Excel to export summaries/ticket lists from our bug tracker. The column I would like to sort by is the "version" column. We use semantic versioning (https://semver.org) because of ...
- 25
0
votes
2
answers
25
views
Sort out whose who are still working by date
I have an Excel file with 4 columns: Name, Staff_No, Date_Joined, Date_Left.
My boss wants to know those who are still working.
The output should look: Name, Staff_No, Date_Joined.
Any idea for the ...
- 1
0
votes
1
answer
243
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
- 45