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

Attached Images

	unsorted.jpg (192.6 KB, 23 views)
	sorted.jpg (206.2 KB, 23 views)

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Attached Files

List of names.xlsx (12.1 KB, 13 views)

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?

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