Sorting

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top