All Questions
1,325
questions
0
votes
3
answers
74
views
Excel: sort an array by an ordered list, without custom list
I have a table of post codes, with the amount of shipments being sent to each postcode.
I want to sort this array by post code in a specific order, which I have in a second list.
I do not wish to sort ...
0
votes
0
answers
32
views
VBA Sort horizontally on current selection
I have to order and sort several workbooks of different column lengths and row amounts. I would like the script to be dynamic in the selection. The starting point will always be the same C1. The ...
0
votes
2
answers
53
views
Is there a way to sort out alphanumeric codes in Excel from a string with zero uniformity?
So I have a list of parts that have been ordered for the maintenance crew at my job. There is almost zero uniformity across different records. Some are just a string of 6 numbers, others have letters, ...
1
vote
0
answers
30
views
xlDown stops at line 166 everytime
I have to make small list out of a large data set that has new values added to it weekly. The macros are to delete the unnecessary data and format whats left depending on the list requirements.
This ...
-1
votes
0
answers
31
views
Using Excel, retrieve past maintenance data based on which vehicle is in use today
So I have data that is split across 3 sheets (cannot change that). I have a log of all cars available All Cars, what maintenance has been done to them recently Maintenance, and then a display board of ...
0
votes
0
answers
70
views
Highlighting Mismatch cells and sorting them at the top
Application.ErrorCheckingOptions.NumberAsText= False
Dim lastRow As Long
Dim i As Long, j As Long
Dim Tiger, Lion, recon As Worksheet
Dim compareRange As Range
Dim cell As Range
Dim dict As Object
...
-1
votes
4
answers
142
views
Adding empty rows between values while using Filter or Sort
Hi I am wondering if I can add empty values to filter or sort formulas in excel.
My idea is to create an empty row to separate the results.
So for instance, this is a result of a sort function:
I ...
0
votes
1
answer
46
views
Sorting by multiple keys
I have the below code with SheetName = "SS Colors", and First, Second, Third,... equal to a string representation of ranges such as First ="a5:a174", Second = "B5:B174",.....
0
votes
0
answers
34
views
Excel VBA: Auto sort column when formula result changes
I'm trying to get VBA to auto sort a column in a Table in Excel when the formula result in the cells in the same column are changed/updated. However, the auto sort code shown below is not triggering ...
0
votes
1
answer
62
views
Rearrange / Reorder Columns in Excel based on the headers which are numbers
I have an excel file which consists of headers with Numbers like below and I want them to be reordered in an Ascending order from left to right including the column data with an excel macro. can ...
0
votes
1
answer
158
views
Why does a `UNIQUE(TEXTSPLIT(TEXTJOIN(...)))` not yield a list of unique values?
I was trying to help solving this question.
My proposal was based on the idea to get unique identifiers, using the Unique() worksheet function.
So, in cell "B1" I put the value "1,2,3,4,...
0
votes
1
answer
44
views
Sorted order not reflected in excel while writing a sorted dataframe
In this Python program, I am reading an excel file and sorting the same based on a particular sort order defined in the program. I want to replace the contents original file with the sorted data. ...
1
vote
3
answers
121
views
How do you combine multiple column pairs into one table (with zeros for missing values)?
I have many column pairs (mass spectral data) that I want to combine into one array with the zeros for the missing rows.
I have something like this:
column pairs
Mass
10
Mass
11
Mass
12
Mass
13
80
...
2
votes
5
answers
82
views
Excel, sort by row
Is there a way to sort by row in an Excel spreadsheet? For example, if I have something like this...
How can I sort, alphabetically, by rows, so it would look like this...
Thanks in advance.
0
votes
1
answer
62
views
Resort from descending to ascending
I have a large two part macro.
The first part vlookups data into a "master" sheet and sorts by the vlookup column so any #N/As are on top.
The idea to manually correct any #N/As from the ...