Excel Lookup
 

I have a spreadsheet that has three columns One column contains A, B or C
depending on the product. the other column contains the account number 4
digits and the third column contains the route names.

The account numbers can have an A, B, and / or C next to them depending on
the product they ordered for that day.
I want to sort the A's out and keep the B & C together sorted with their
accounts numbers and their routes

Any help would be greatly appreciatted.

This changes daily.
So I'd like to get a macro or formula or something

Excel Lookup
 

Add a helper column with a formula of

=IF(A1="A",0,ROW())

and sort by that helper column

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LostNFound" wrote in message
...
I have a spreadsheet that has three columns One column contains A, B or C
depending on the product. the other column contains the account number 4
digits and the third column contains the route names.

The account numbers can have an A, B, and / or C next to them depending on
the product they ordered for that day.
I want to sort the A's out and keep the B & C together sorted with their
accounts numbers and their routes

Any help would be greatly appreciatted.

This changes daily.
So I'd like to get a macro or formula or something