Sorting

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Hi,

What I want to do is the following:

A B
box empty
car empty
car gas
box empty
train empty
box corn

I have the above list in a spreadsheet, but it is much
longer, with additional columns with other information in
it. I have a formula now that takes all the empty's and
sorts them to the top of the page, so the above list looks
like this:

A B
box empty
car empty
box empty
train empty
box corn
car gas


What I want it to do is once it pulls all the empty's to
the top, I want it to sort just the rows that have empty
in column B by column A, so it would look like:

A B
box empty
box empty
car empty
train empty
box corn
car gas

Any help would be apprecitated.

mary
 
I don't want anything but the empties to be sorted by
column A. The train and cars and others, i neeed to stay
the way they occur naturally. Just sorting the ones that
say "empty". I am trying to find a formula or macro that
will do this for me.

Mary
 
Back
Top