M
maria86004
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) How do I explain this?
I have an excel spread sheet that I got from the county assesor.
They gave me a list of names and addresses.
Name is in one column, street address in another,city in one, state in one, zip code in another.
In Column D is the city. Most of the cities are listed as Flagstaff. I am trying to sort these out for two mailings. First I want to make a list of all of the rows that list in Column D as any city But Flagstaff.
Then I want a second list of all rows that list in column d as Flagstaff.
Is there a way I could perhaps sort this list by having all of the Flagstaff rows at the top of the page and then all of the other city rows at the bottom?
I am trying to do two mailings and the printer said to give her two lists on an excel spread sheet.
Or do I just have to do this manually.
If anyone has any ideas on how to make this task simpler, I sure would appreciate it. I have 5000 rows of addresses to sort.
I have an excel spread sheet that I got from the county assesor.
They gave me a list of names and addresses.
Name is in one column, street address in another,city in one, state in one, zip code in another.
In Column D is the city. Most of the cities are listed as Flagstaff. I am trying to sort these out for two mailings. First I want to make a list of all of the rows that list in Column D as any city But Flagstaff.
Then I want a second list of all rows that list in column d as Flagstaff.
Is there a way I could perhaps sort this list by having all of the Flagstaff rows at the top of the page and then all of the other city rows at the bottom?
I am trying to do two mailings and the printer said to give her two lists on an excel spread sheet.
Or do I just have to do this manually.
If anyone has any ideas on how to make this task simpler, I sure would appreciate it. I have 5000 rows of addresses to sort.