Or if you are not OK with macros....
Arrange your data this way:

Help1 Help2 Data Criteria
1 0 4012 Test
2 0 4012 FALSE
3 1 4012
4 0 4013
5 1 4013
6 0 4014
7 4014

Tools Options General R1C1 Reference Style
Select the 8 row, 3 column array and do
Insert Name Create Top Row
Select the next 3 row vector and do
Insert Name Create Top Row
Fill Help2 with this formula:
=--NOT((Data R[1]=Data))
Fill the cell that says FALSE with =Help2=1
Data Filter Advanced Filter Copy To Another Selection
List Range Select the array as above
Criteria Range Type in Criteria
Copy To Select first empty cell below Help1 OK
Delete the Help2 column.
Format the appended data with a unique format, say red font.
Select all the data in the first 2 columns and sort by Help1.
Edit Replace Format red font Replace all