| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting question sort of
I am looking for a way to move my data up without using sort. In the example
below there is a list of employees, what I need is something that will give the result shown in the second example after I removed Bill and Nancy. The items can not be sorted since they have to maintain there position relative to each other. Deleting the cells (and having the cells below move up) is not an option. Nor is it an option to create a hidden row and assigning each name a ranking number to sort on. B3 = John B4 = Bill B5 = Linda B6 = Adam B7 = Nancy B8 = Robert B9 = Brian B3 = John B4 = Linda B5 = Adam B6 = Robert B7 = Brian B8 = B9 = |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SORT is sorting my headings amongst the data | Excel Discussion (Misc queries) | |||
| Hard to Sort Sorting | Excel Discussion (Misc queries) | |||
| Sort rows without sorting... | Excel Discussion (Misc queries) | |||
| sort macro stopped sorting | Excel Programming | |||
| Sorting - use of variable sort key | Excel Programming | |||
![ordnance1[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
