Hi,
I have sorted a list by a number of levels within excel to find groups of data. I would now like to order those groups of data from the highest frequency of duplicate values to the lowest frequency of duplicate values.
E.g. Currently my excel sheet list looks like this:
Column Column Column Column Column
A B C D E
No | Applicant Name | Applicant Surname | Respondent Name | Respondent Surname
1 A B C D
2 A B C D
3 E F G H
4 I J K L
5 I J K L
6 I J K L
7 M N O P
However, I would like to keep the data together but order the data from the largest amount of duplicate rows to the least amount of duplicate rows (i.e. keeping the entire row together where the values from columns B-E are the same), so it would look instead like this:
Column Column Column Column Column
A B C D E
No | Applicant Name | Applicant Surname | Respondent Name | Respondent Surname
4 I J K L
5 I J K L
6 I J K L
1 A B C D
2 A B C D
3 E F G H
7 M N O P
How can this be done? Does it require a macro of some sort? I have looked all over the internet for an answer so help would be great...!
Thanks, Chris
Bookmarks