Excel:Sorting2
Closed
Somerandomdude
-
Oct 4, 2011 at 06:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2011 at 08:43 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2011 at 08:43 PM
Related:
- Excel:Sorting2
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 6, 2011 at 08:43 PM
Oct 6, 2011 at 08:43 PM
The way i see the solution is
1. in one column have the the current row number of each row (you can use =ROW() and then use copy and paste to convert to values. You must have value and not formula here)
2. in the other column have a count of each country (you can use countif)
3. sort on the countif column
4. now you you have to cut and paste each row where it was destination (ROW number will tell you which row to paste at)
1. in one column have the the current row number of each row (you can use =ROW() and then use copy and paste to convert to values. You must have value and not formula here)
2. in the other column have a count of each country (you can use countif)
3. sort on the countif column
4. now you you have to cut and paste each row where it was destination (ROW number will tell you which row to paste at)