Daily posts of Excel tips…and other stuff
Archive for the ‘Sorting’ Category.
In the above (obviously contrived) example, a company changed accounting systems. Any open projects at the time were converted to the new system, but were assigned new project numbers and names. Now the company needs to sort the reports by project number, but they want those jobs that have two different numbers to [...]
Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]
El Says:
“I have a spreadsheet with dates and on each day, there are several activities with start time and end time. I want to add a row between each day, and also to add up the total time for all the activities in each day.”
This is where the Subtotals feature is quite useful.
It can add [...]
A few days ago I solved a problem that I've been working on for more than five years: How to create a multi-cell array formula that returns a sorted list of text entries. It's easy enough to do this with numeric entries, but the text solution has eluded me.
Range A2:A21 is named data. Select C2:C21 [...]
Jim T. sends this along, and I’m not sure what’s causing this behavior. Maybe you know and comment on it.
Col. D and Col. E are identical except that Col. E’s formula has range references that include the sheet name.
If you sort Col. D without sorting any other data on the sheet, you get the [...]
In Sort On More Than Three Columns, I described how to short your data in two steps. Mark’s tip for sorting on more than three columns uses a helper column.
Using another column, you can concantenate the columns you want to sort and sort on that column. This example sorts on four columns by using a [...]
From Jan, a workbook that doesn’t sort quite right. The four numbers in column A are sorted ascending with a header row
This often happens with imported or copied and pasted data. It all looks normal because the cells are right justified. If you remove the justification, you would see that only the [...]
