All Questions
Tagged with microsoft-excel-2016 sorting
13
questions
0
votes
1
answer
471
views
Keeping two rows together when sorting
I would like to know how to link specific rows when sorting a table in excel. I have already made the table and in each row contains data for a specific person. Each person has two rows. My boss would ...
1
vote
1
answer
5k
views
Pivot Table: Sort row by hidden field
I have a table in Excel 2016 (source: Microsoft Query/ODBC):
Raw data:
Construction Type Location Sort
Reconstruction Main St - Red St to Blue St 1
...
- 157
0
votes
1
answer
57
views
Sorting and ordering two expense lists by a third list of categories using Excel 2016
I want to use Excel 2016 to sort two expense lists by a third list of categories.
The first catch is that I want to place the value in the same cell like the categoris list – It's not a simple sort, ...
- 147
0
votes
0
answers
40
views
How to add only values in one column that have a unique value and still be able to retain the sum even after sorting?
Original Problem
just an addition to this problem. the sum of the column changes when sorting out a different column. is there a way that we retain the sum even after sorting?
RTN sorted
Example:
I ...
3
votes
3
answers
28k
views
How do I sort a values with letters and numbers?
I have a column with values like these
A1
A-3 // reads: A (minus 3)
J24
J-2
A24
...
Now I want to sort them first by the leading letter. Then by the following number. But Excel reads the minus as ...
user1005339
0
votes
0
answers
234
views
Excel 2016 alphabethical sort doesn't seem to work correctly
I use an English installation of Windows, but an Swedish installation of Office 2016. When I sorted a couple of rows alphabethically today, the result was very strange. Apparently, Excel 2016 doesn't ...
0
votes
1
answer
2k
views
Counting t-shirt sizes in a column but also separated by commas
I am counting sizes in a column but some of the cells also have extra sizes separated by a comma. The problem I am running into is counting "L" "XL" and "XXL".
The formula I am using to count "S" ...
- 1
0
votes
1
answer
327
views
Sophisticated dates sorting in MS Excel?
There is an Excel 2016 file with data about some events, the main sheet contains an ID and a date for each event, like this:
ID Date
1 2017-10-02
2 2017
3 2017-09
4 2017-09-25
… etc.
Most ...
user628454
4
votes
1
answer
558
views
Sort an Excel range that is greater than an Excel table
I have 2 parallel (side by side) same-height Excel tables with a completely blank column (no data, nor header) in between them. The rows of a table correspond to the same rows of the other table (so ...
- 375
6
votes
2
answers
44k
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 ...
- 61
1
vote
1
answer
961
views
How do you sort in Excel using two pairs of cells?
I am working on a spreadsheet where I have certain data organised in this format:
Row 1: [Train Origin]
Row 2: [Train Destination]
Row 3: [Train Code]
The items are organised in ...
- 13
0
votes
1
answer
335
views
How to separate unique values into sheets?
I have an excel file with around 10.000 leads, categorized with Name, Email, Company name, Position, City, CheckedEmailAddress, Mail server Country Code,
last one Mail server Country Code, there are ...
- 11
0
votes
3
answers
508
views
Sorting in MS Excel 2016
I am sorting in MS Excel 2016.
DATA:
***Column*** A
***Header*** Room
***(data)*** A16
A116
A21
A15
Sort: Sort Warning. I chose "Continue with the current ...
