Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
austin yarnell's user avatar
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 ...
User1974's user avatar
  • 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, ...
jonatr's user avatar
  • 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 ...
fresh_french's user avatar
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 ...
user avatar
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 ...
Johan Nilsson's user avatar
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" ...
TLK7's user avatar
  • 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 ...
user avatar
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 ...
SAL's user avatar
  • 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 ...
Mariangela's user avatar
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 ...
macman644's user avatar
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 ...
Edin Neziri's user avatar
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 ...
user684612's user avatar