Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows with same address
I have a spreadsheet with 6 columns; 1-name (last name, first name),
2-address1, 3-address2 4-city, 5-state and 6-zip code. The spreadsheet shows members of my organization. I am trying to stop sending two mailings to the same address to save postage. I need help in creating a formula or a macro to: 1. Sort by zip code, state, city, address1 and address2 2. Check to see if address is the same as one above. 3. If so, check to see if last name is the same as one above 4. If 3 & 4 are yes, take the first name of the second row and add it to the first name of the first row, insert an ampersand (&) [e.g. Jane & Joe Doe) 5. Delete the second row Any and all help will be appreciated! -- NOEL@HOME |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows with same address
Fairly simple. Easier if you just send your wb to my address below instead of me re-creating it. -- Don Guillett Microsoft MVP Excel SalesAid Software "noel" wrote in message ... I have a spreadsheet with 6 columns; 1-name (last name, first name), 2-address1, 3-address2 4-city, 5-state and 6-zip code. The spreadsheet shows members of my organization. I am trying to stop sending two mailings to the same address to save postage. I need help in creating a formula or a macro to: 1. Sort by zip code, state, city, address1 and address2 2. Check to see if address is the same as one above. 3. If so, check to see if last name is the same as one above 4. If 3 & 4 are yes, take the first name of the second row and add it to the first name of the first row, insert an ampersand (&) [e.g. Jane & Joe Doe) 5. Delete the second row Any and all help will be appreciated! -- NOEL@HOME |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting large gaps in address | Excel Discussion (Misc queries) | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
How do I move up rows below blank rows in an address? | Excel Worksheet Functions | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) |