Mardy McFly
New Member
- Joined
- Nov 27, 2016
- Messages
- 2
Hello Eveyone,
I have a customer list from which I am trying to create mailing labels. The list is generated with 1 line per customer (First Name, Last Name, Address). I need to have the output of the names on the label different depending on the situation.
1. If the same address has all the same last name then I need the out put to be "The [Last Name] Family"
2. If the same address has more than one last name then I need the out put to be "[First Name] [Last Name] & [First Name] [Last Name]..." for as many names as are at the address
I have tried If AND/OR formulas, but I cannot get the 2. scenario to out put if there are more than 2 last names at an address. I'm wondering if there is a macro that could do it?
Any help would be appreciated.
Sample Data:
<tbody>
</tbody>
I have a customer list from which I am trying to create mailing labels. The list is generated with 1 line per customer (First Name, Last Name, Address). I need to have the output of the names on the label different depending on the situation.
1. If the same address has all the same last name then I need the out put to be "The [Last Name] Family"
2. If the same address has more than one last name then I need the out put to be "[First Name] [Last Name] & [First Name] [Last Name]..." for as many names as are at the address
I have tried If AND/OR formulas, but I cannot get the 2. scenario to out put if there are more than 2 last names at an address. I'm wondering if there is a macro that could do it?
Any help would be appreciated.
Sample Data:
first_name | last_name | Address | City | State | Zip |
Nicholas | Robertson | 0 Barnett Circle | Waco | TX | 76796 |
Benjamin | Robertson | 0 Barnett Circle | Waco | TX | 76796 |
Maria | Woods | 0 Bluestem Junction | Mobile | AL | 36622 |
Karen | Kelly | 0 Browning Crossing | Pasadena | CA | 91199 |
Theresa | Lawrence | 0 Browning Crossing | Pasadena | CA | 91199 |
Ruby | Carter | 0 Browning Crossing | Pasadena | CA | 91199 |
Julia | Scott | 0 Dorton Trail | Corpus Christi | TX | 78465 |
Carlos | Black | 0 Fairfield Plaza | Las Vegas | NV | 89150 |
Kathryn | Black | 0 Fairfield Plaza | Las Vegas | NV | 89150 |
Gerald | Black | 0 Fairfield Plaza | Las Vegas | NV | 89150 |
Eugene | Hernandez | 0 Hanover Plaza | Wilmington | DE | 19897 |
Anne | Ortiz | 0 Hoepker Parkway | San Diego | CA | 92110 |
Cynthia | Howard | 0 Manufacturers Center | San Antonio | TX | 78260 |
Louis | Burke | 0 Manufacturers Center | San Antonio | TX | 78260 |
Rachel | Patterson | 0 Meadow Valley Avenue | San Diego | CA | 92170 |
Jonathan | Bradley | 0 Novick Pass | Dallas | TX | 75372 |
Annie | Bradley | 0 Novick Pass | Dallas | TX | 75372 |
Timothy | Bradley | 0 Novick Pass | Dallas | TX | 75372 |
Barbara | Spencer | 0 Sachs Plaza | Detroit | MI | 48232 |
Amanda | Gomez | 0 Spohn Parkway | North Port | FL | 34290 |
Billy | Kim | 0 Sutteridge Trail | Camden | NJ | 8104 |
Cheryl | Nichols | 0 Sutteridge Trail | Camden | NJ | 8104 |
Jacqueline | Rodriguez | 0 Sutteridge Trail | Camden | NJ | 8104 |
Antonio | Weaver | 00 Lunder Pass | San Diego | CA | 92160 |
Dorothy | Weaver | 00 Lunder Pass | San Diego | CA | 92160 |
Albert | Weaver | 00 Lunder Pass | San Diego | CA | 92160 |
Jean | Weaver | 00 Lunder Pass | San Diego | CA | 92160 |
<tbody>
</tbody>