All Questions
12
questions
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 ...
0
votes
2
answers
1k
views
Excel Sort Command not working AT ALL as expected
I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways:
the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
0
votes
1
answer
1k
views
How to group multiple date|data columns to one single date column on the left?
I've got a large set of data that looks like:
and I've been trying to format it so that instead of having a column of dates for each item, there's only one column of dates on the left. The problem is ...
-1
votes
1
answer
43
views
Sorting rows: 6 transactions with date and action information grouped together
I need to organize transaction information in a spreadsheet by ascending date order. Each row represents a single person and the last 6 transactions in their history. The problem is that while the ...
0
votes
1
answer
1k
views
Sorting one column of data into multiple columns
If I have a list of data in a spreadsheet like this:
John
123-456-7890
[email protected]
Sally
987-654-3210
[email protected]
.
.
.
What would be the quickest and cleanest way to sort the data into rows ...
1
vote
3
answers
1k
views
Spreadsheet: create column based on one column sorted by values of another
I want to create a new column of data from one column sorted by another column.
It's easiest to explain with an example. This is not actually what I'm doing, but I think it explains it well.
Let's ...
0
votes
1
answer
119
views
How to Sort unique Contacts?
I have a list of 35k contacts, I need to sort unique after unique
I demonstrated in this example how I want to sort contacts:
I tried by removing duplicates then to copy unique and to go back to ...
0
votes
2
answers
177
views
Excel sorted heading won't sort data in whole spreadsheet
So I would like to be able sort all my data using the little drop down arrow created by the filter function, all the way from F to JE.
At the moment it will only sort from F to AK.
Any idea how I ...
0
votes
2
answers
381
views
How to sort columns in Excel so that only one value appears in each row?
Say I have a a spreadsheet with the following data:
A B C D
---------------------
2 1 0 2
3 2 1 4
5 3 3 6
7 5 6 8
11 8 10 10
...
22
votes
1
answer
68k
views
How to sort an Excel spreadsheet columns by row contents?
How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
2
votes
1
answer
2k
views
Two Spreadsheets, Merge Data?
I was wondering what is the best way to merge two spreadsheets which have the name id's e.g:
One sheet has:
apple 5
dog 3
cat 2
Second sheet:
dog 4
apple 7
cat 3
I would like ...
0
votes
1
answer
1k
views
Autosort microsoft excel worksheet
Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?