| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting one column, move some duplicates to bottom of sort
I have a button that sorts multiple columns based on one row. in another row
there are duplicate values ( Peoples names). i would like to keep all records but would like to send the duplicates to the bottom. sorry I'm not sure of the proper way to ask this. so here is a basic example. John Doe; 678 Jane Doe; 654 John Doe: 721 Jim Smith; 672 Jim Smith; 673 John Doe; 688 Sam Andrews; 700 I would like the above to sort like this John Doe; 721 Sam Andrew; 700 Jim Smith; 673 Jane Doe; 654 John Doe; 688 John Doe; 678 Jim Smith; 672 Sort the number column largest to smallest; keep any lower number duplicate names sorted on the bottom. Many Thanks in advance Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Duplicates in a Column (Without Sorting) | Excel Discussion (Misc queries) | |||
| How to Move from bottom of one column to top of next | Excel Discussion (Misc queries) | |||
| HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
| Move to bottom of Column | Excel Programming | |||
| Shortcut to move to bottom (last) cell in a column | Excel Discussion (Misc queries) | |||
Threaded Mode
