#1
|
|||
|
|||
Sorting cells with duplicates values
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 |
#2
|
||||
|
||||
Please post a sample sheet ( eventually mock-up data) instead of pictures which are useless
Click go advanced - Manage attachments and follow the wizard
__________________
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 |
#3
|
|||
|
|||
Sorting cells with duplicates values
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 |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
Sorting
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting with blank cells | mummy | Excel | 1 | 09-02-2017 06:04 AM |
I need help with Sorting and adding cells, it sound basis however it is more complicated than that. | will soar | Excel | 2 | 02-23-2017 01:38 PM |
Sorting cells alphabetically | jenpen | Word | 5 | 11-16-2015 11:35 PM |
Linking cells: can sub-cells move with their master-cell when sorting? | kw01 | Excel | 1 | 06-30-2015 05:02 PM |
Sorting Alphanumeric & Numeric values | slovenc0417 | Excel | 2 | 06-07-2013 07:58 PM |