Sorting on four coloumns

[Jabj]

Hi,

I have the following sheet and code which at the moment are not working as it should be. What I want is to sort

1) First Colounm F,
2) Then Colounm B,
3) Then Colounm D,
4) and last Colounm E

Please advice how I can add the fourth sorting so the above ranking is applied.

Thanks!

[Logit]

.
There is probably a 'prettier' way to do this, however running the Macro Recorder results in this code which gets the job done:

Please Login or Register  to view this content.

[Jabj]

Hi Logit,

Maybe I did not expressed myself well enough.
The data in column A:F is a dataset and therefore I need to make the above sorting (F, B, D, E) for the whole dataset and not just taking one coloumn after eachother.

Also, I have some data above in row 1 so I can't just take "whole" coloumns but need to sort in the specific "data field".

Appreciate the feedback

[LJMetzger]

Hi Jabj,

Your profile indicates you are using Excel 2003. To the best of my knowledge, without trickery, Excel 2003 can only sort 3 columns.

However if you add a 'Helper Column', you may be able to do what you want. Since your test file does not include any data in Column 'F', the following is a hypothetical.

Data as follows:
a. Text or Number in Column 'F' (ffff)
b. Text or Number in Column 'B' (bbbb)
c. Date in Column 'D' (March 11, 2017)
d. Text or Number in Column 'E' (1.233)

a. Create a Helper Column that concatenates the data you want to sort in the order you want the data sorted. The LEFT function creates a string padded with spaces. The spaces are needed to make sure each field sorts correctly. If the LEFT function contains the number 20, make sure there are at least 20 spaces between the double quotes.
b. Include the Helper Column in your data, and sort with the Helper Column as the key.
c. The Helper Column can be hidden to preserve PRETTY PRINT for your data.

Please Login or Register  to view this content.

The formula will create a text string that looks like:

Please Login or Register  to view this content.

NOTE: apostrophes are NOT in the text string'

I hope this helps.

Lewis

[Arkadi]

The example has data in A to E, not A to F, if that's the case this code may not work, but in theory this should do what you ask? It first sorts by E, then does the other 3, which makes E the last sort criteria.

Please Login or Register  to view this content.