Deleting the cells (and having the cells below move up) is not an option.

Based on your example, I don't see why the above would do what you want. Is
there other data that is involved? If so, what happens to the data that was
assigned to Bill and Nancy?

--
Rick (MVP - Excel)



"ordnance1" wrote in message
...
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 =