sorting rows with unique identifier and then duplicate identifier

Hi All,

I have set of data that has unique "Code" and duplicate "Codes". I was trying to figure out the VBA code that would sort my set of data with unique identifier that is "Code" in the first order and then the duplicate identifier that is again "Code" in the second order. The separated unique and duplicate identifiers are then sorted in their dates order.

I am attaching the test file for your ready reference.

Pic1.PNG

Thank you
Roshan Shakya

1. Sorting with unique Transaction Code.xlsx

Originally Posted by Roshan.Shakya

... the VBA code that ... sort ...
1. data with unique identifier in the first order ...
2. then the duplicate identifier ... in the second order.
3. The separated unique and duplicate identifiers are then sorted in their dates order.

Why a macro here ? An helper column with the formula is enough, e.g.:

a) in 'E1' enter some headline
b) in 'E2' enter formula and copy down:

=IF(COUNTIF($B$2:$B$24;$B2)=1;1;2) & "-" & $B2 & $C2

then sort.

Excellent Alsace, thank you.

Roshan Shakya

Excellent Drevni,

Thank you
Roshan Shakya