Sorting cells with duplicates values

[allex011]

Could someone help me to find the way to sort cells in sheet.I have sheet that contains approximately 25000 rows with parents name, surname, ID number and children number.Is there a possibility to sort cells in sheet by ID number of parent (parent with one children, parents with two children..)?
Thank in andvanced

[Pecoflyer]

Please post a sample sheet ( eventually mock-up data) instead of pictures which are useless
Click go advanced - Manage attachments and follow the wizard

[allex011]

Could someone help me to find the way to sort cells in sheet.I have sheet that contains approximately 25000 rows with parents name, surname, ID number and children number.Is there a possibility to sort cells in sheet by ID number of parent (parent with one children, parents with two children..)?
Thank in andvanced

[xor]

Can't you just use a COUNTIF formula in D2 as follows:

=COUNTIF($A$2:$A$100,A2)

copy down to A100. Then sort A1:d100 by column D, Add Level and Then by ID number?

[Berny]

I will have to agree with "xor" comments, you should do the count formula first,

=COUNTIF($B$2:$B$100,B2)

I added this formula in column D

then use the sort options as shown below found on the HOME ribbon on the top right, sort by ID add a level and sort by No. of Child