Combining Names in Customer List

[Mardy McFly]

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:

[TABLE="width: 641"]
<tbody>[TR]
[TD]first_name[/TD]
[TD]last_name[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[/TR]
[TR]
[TD]Nicholas[/TD]
[TD]Robertson[/TD]
[TD]0 Barnett Circle[/TD]
[TD]Waco[/TD]
[TD]TX[/TD]
[TD="align: right"]76796[/TD]
[/TR]
[TR]
[TD]Benjamin[/TD]
[TD]Robertson[/TD]
[TD]0 Barnett Circle[/TD]
[TD]Waco[/TD]
[TD]TX[/TD]
[TD="align: right"]76796[/TD]
[/TR]
[TR]
[TD]Maria[/TD]
[TD]Woods[/TD]
[TD]0 Bluestem Junction[/TD]
[TD]Mobile[/TD]
[TD]AL[/TD]
[TD="align: right"]36622[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]Kelly[/TD]
[TD]0 Browning Crossing[/TD]
[TD]Pasadena[/TD]
[TD]CA[/TD]
[TD="align: right"]91199[/TD]
[/TR]
[TR]
[TD]Theresa[/TD]
[TD]Lawrence[/TD]
[TD]0 Browning Crossing[/TD]
[TD]Pasadena[/TD]
[TD]CA[/TD]
[TD="align: right"]91199[/TD]
[/TR]
[TR]
[TD]Ruby[/TD]
[TD]Carter[/TD]
[TD]0 Browning Crossing[/TD]
[TD]Pasadena[/TD]
[TD]CA[/TD]
[TD="align: right"]91199[/TD]
[/TR]
[TR]
[TD]Julia[/TD]
[TD]Scott[/TD]
[TD]0 Dorton Trail[/TD]
[TD]Corpus Christi[/TD]
[TD]TX[/TD]
[TD="align: right"]78465[/TD]
[/TR]
[TR]
[TD]Carlos[/TD]
[TD]Black[/TD]
[TD]0 Fairfield Plaza[/TD]
[TD]Las Vegas[/TD]
[TD]NV[/TD]
[TD="align: right"]89150[/TD]
[/TR]
[TR]
[TD]Kathryn[/TD]
[TD]Black[/TD]
[TD]0 Fairfield Plaza[/TD]
[TD]Las Vegas[/TD]
[TD]NV[/TD]
[TD="align: right"]89150[/TD]
[/TR]
[TR]
[TD]Gerald[/TD]
[TD]Black[/TD]
[TD]0 Fairfield Plaza[/TD]
[TD]Las Vegas[/TD]
[TD]NV[/TD]
[TD="align: right"]89150[/TD]
[/TR]
[TR]
[TD]Eugene[/TD]
[TD]Hernandez[/TD]
[TD]0 Hanover Plaza[/TD]
[TD]Wilmington[/TD]
[TD]DE[/TD]
[TD="align: right"]19897[/TD]
[/TR]
[TR]
[TD]Anne[/TD]
[TD]Ortiz[/TD]
[TD]0 Hoepker Parkway[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD="align: right"]92110[/TD]
[/TR]
[TR]
[TD]Cynthia[/TD]
[TD]Howard[/TD]
[TD]0 Manufacturers Center[/TD]
[TD]San Antonio[/TD]
[TD]TX[/TD]
[TD="align: right"]78260[/TD]
[/TR]
[TR]
[TD]Louis[/TD]
[TD]Burke[/TD]
[TD]0 Manufacturers Center[/TD]
[TD]San Antonio[/TD]
[TD]TX[/TD]
[TD="align: right"]78260[/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD]Patterson[/TD]
[TD]0 Meadow Valley Avenue[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD="align: right"]92170[/TD]
[/TR]
[TR]
[TD]Jonathan[/TD]
[TD]Bradley[/TD]
[TD]0 Novick Pass[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD="align: right"]75372[/TD]
[/TR]
[TR]
[TD]Annie[/TD]
[TD]Bradley[/TD]
[TD]0 Novick Pass[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD="align: right"]75372[/TD]
[/TR]
[TR]
[TD]Timothy[/TD]
[TD]Bradley[/TD]
[TD]0 Novick Pass[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD="align: right"]75372[/TD]
[/TR]
[TR]
[TD]Barbara[/TD]
[TD]Spencer[/TD]
[TD]0 Sachs Plaza[/TD]
[TD]Detroit[/TD]
[TD]MI[/TD]
[TD="align: right"]48232[/TD]
[/TR]
[TR]
[TD]Amanda[/TD]
[TD]Gomez[/TD]
[TD]0 Spohn Parkway[/TD]
[TD]North Port[/TD]
[TD]FL[/TD]
[TD="align: right"]34290[/TD]
[/TR]
[TR]
[TD]Billy[/TD]
[TD]Kim[/TD]
[TD]0 Sutteridge Trail[/TD]
[TD]Camden[/TD]
[TD]NJ[/TD]
[TD="align: right"]8104[/TD]
[/TR]
[TR]
[TD]Cheryl[/TD]
[TD]Nichols[/TD]
[TD]0 Sutteridge Trail[/TD]
[TD]Camden[/TD]
[TD]NJ[/TD]
[TD="align: right"]8104[/TD]
[/TR]
[TR]
[TD]Jacqueline[/TD]
[TD]Rodriguez[/TD]
[TD]0 Sutteridge Trail[/TD]
[TD]Camden[/TD]
[TD]NJ[/TD]
[TD="align: right"]8104[/TD]
[/TR]
[TR]
[TD]Antonio[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD="align: right"]92160[/TD]
[/TR]
[TR]
[TD]Dorothy[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD="align: right"]92160[/TD]
[/TR]
[TR]
[TD]Albert[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD="align: right"]92160[/TD]
[/TR]
[TR]
[TD]Jean[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD="align: right"]92160[/TD]
[/TR]
</tbody>[/TABLE]

 

[live_excel]

Hello

i think this formula will help you.

=IF(AND(COUNTIF(B:B,B2)>1,COUNTIF(C:C,C2)>1),"The "&B2&" family",A2&" "&B2)

Please let me know if there any problem.

 

[mikerickson]

This UDF should help.

The AddressFor UDF returns the address of the indicated cells. i.e. =AddressFor(A2:F2) returns "0 Barnett Circle, Waco Tx 76796"
Note that the optional StreetColumn, CityColumn, StateColumn and ZipColumn arguments can specify which columns hold which kind of data. The default to 3,4,5,6 respectively.

That UDF is needed for the AddressTo UDF.
Note the optional DataRange argument of AddressTo. If omitted, it defaults to the entire column of the rngThisData argument.
However if the DataRange argument is omitted, the function becomes volatile. It is preferred that it be specified, even if whole column references are used, this is faster than having a volatile function.

AddressTo also has optional StreetColumn, CityColumn, StateColumn and ZipColumn arguments.

I added another resident to the Texas address to show mixed family and other resident results.

Function AddressTo(rngThisData As Range, Optional dataRange As Range, _
                                Optional FirstColumn As Long, Optional LastColumn As Long, _
                                Optional StreetColumn As Long, Optional CityColumn As Long, _
                                Optional StateColumn As Long, Optional ZipColumn As Long) As String
    
    Const Delimiter As String = " & "
    Dim i As Long
    Dim ThisAddress  As String, strStreet As String, strCity As String, strState As String, strZip As String
    Dim ThisLast As String, ThisName As String
    
    Application.Volatile (dataRange Is Nothing)
    
    If dataRange Is Nothing Then
        Set dataRange = rngThisData.EntireColumn
    End If
    
    If FirstColumn < 1 Then FirstColumn = 1
    If LastColumn < 1 Then LastColumn = FirstColumn + 1
    If StreetColumn < 1 Then StreetColumn = LastColumn + 1
    If CityColumn < 1 Then CityColumn = StreetColumn + 1
    If StateColumn < 1 Then StateColumn = CityColumn + 1
    If ZipColumn < 1 Then ZipColumn = StateColumn + 1
    
    With dataRange
        Set dataRange = Application.Intersect(.Cells, .Parent.UsedRange)
    End With
    
    With rngThisData
        strStreet = .Cells(1, StreetColumn).Value
        strCity = .Cells(1, CityColumn).Value
        strState = .Cells(1, StateColumn).Value
        strZip = .Cells(1, ZipColumn)
    End With
    
    ThisAddress = AddressFor(rngThisData, StreetColumn, CityColumn, StateColumn, 0)
    
    For i = 1 To dataRange.Rows.Count
        If ThisAddress = AddressFor(dataRange.Cells(i, 1), StreetColumn, CityColumn, StateColumn, 0) Then
            ThisLast = dataRange.Cells(i, LastColumn).Value
            
            With dataRange
            If 1 < WorksheetFunction.CountIfs(.Columns(LastColumn), ThisLast, .Columns(StreetColumn), strStreet, .Columns(CityColumn), strCity, _
                            .Columns(StateColumn), strState) Then
                Rem dup family members
                ThisName = StrConv(ThisLast, vbProperCase) & " family"
            Else
                ThisName = StrConv(.Cells(i, FirstColumn) & " " & ThisLast, vbProperCase)
            End If
            
            If Not (AddressTo Like "*" & ThisName & "*") Then
                AddressTo = AddressTo & Delimiter & ThisName
            End If
            End With
        End If
    Next i
    AddressTo = Mid(AddressTo, Len(Delimiter) + 1)
End Function

Function AddressFor(rngThisData As Range, _
                                Optional StreetColumn As Long, Optional CityColumn As Long, _
                                Optional StateColumn As Long, Optional ZipColumn As Long = -1) As String
    
    If StreetColumn < 1 Then StreetColumn = 3
    If CityColumn < 1 Then CityColumn = StreetColumn + 1
    If StateColumn < 1 Then StateColumn = CityColumn + 1
    If ZipColumn < 0 Then ZipColumn = StateColumn + 1
    
    With rngThisData
        If ZipColumn <> 0 Then
            AddressFor = .Cells(1, StreetColumn).Value & ", " & .Cells(1, CityColumn).Value & " " _
                & .Cells(1, StateColumn).Value & " " & .Cells(1, ZipColumn).Value
        Else
            AddressFor = .Cells(1, StreetColumn).Value & ", " & .Cells(1, CityColumn).Value & " " _
                & .Cells(1, StateColumn).Value
        End If
    End With
    AddressFor = WorksheetFunction.Trim(AddressFor)
    AddressFor = StrConv(AddressFor, vbProperCase)
End Function

Unknown
	A	B	C	D	E	F	G	H	I
1	first_name	last_name	Address	City	State	Zip
2	Nicholas	Robertson	0 Barnett Circle	Waco	TX	76796		Robertson family & Mary Hastings	0 Barnett Circle, Waco Tx 76796
3	Benjamin	Robertson	0 Barnett Circle	Waco	tx	76796		Robertson family & Mary Hastings	0 Barnett Circle, Waco Tx 76796
4	Maria	Woods	0 Bluestem Junction	Mobile	AL	36622		Maria Woods	0 Bluestem Junction, Mobile Al 36622
5	Karen	Kelly	0 Browning Crossing	Pasadena	CA	91199		Karen Kelly & Theresa Lawrence & Ruby Carter	0 Browning Crossing, Pasadena Ca 91199
6	Theresa	Lawrence	0 Browning Crossing	Pasadena	CA			Karen Kelly & Theresa Lawrence & Ruby Carter	0 Browning Crossing, Pasadena Ca
7	Mary	Hastings	0 Barnett Circle	Waco	TX	76796		Robertson family & Mary Hastings	0 Barnett Circle, Waco Tx 76796
8	Ruby	Carter	0 Browning Crossing	Pasadena	CA	91199		Karen Kelly & Theresa Lawrence & Ruby Carter	0 Browning Crossing, Pasadena Ca 91199
9	Julia	Scott	0 Dorton Trail	Corpus Christi	TX	78465		Julia Scott	0 Dorton Trail, Corpus Christi Tx 78465
10	Carlos	Black	0 Fairfield Plaza	Las Vegas	NV	89150		Black family	0 Fairfield Plaza, Las Vegas Nv 89150
11	Kathryn	Black	0 Fairfield Plaza	Las Vegas	NV	89150		Black family	0 Fairfield Plaza, Las Vegas Nv 89150
12	Gerald	Black	0 Fairfield Plaza	Las Vegas	NV	89150		Black family	0 Fairfield Plaza, Las Vegas Nv 89150
13	Eugene	Hernandez	0 Hanover Plaza	Wilmington	DE	19897		Eugene Hernandez	0 Hanover Plaza, Wilmington De 19897
14	Anne	Ortiz	0 Hoepker Parkway	San Diego	CA	92110		Anne Ortiz	0 Hoepker Parkway, San Diego Ca 92110
15	Cynthia	Howard	0 Manufacturers Center	San Antonio	TX	78260		Cynthia Howard & Louis Burke	0 Manufacturers Center, San Antonio Tx 78260
16	Louis	Burke	0 Manufacturers Center	San Antonio	TX	78260		Cynthia Howard & Louis Burke	0 Manufacturers Center, San Antonio Tx 78260
17	Rachel	Patterson	0 Meadow Valley Avenue	San Diego	CA	92170		Rachel Patterson	0 Meadow Valley Avenue, San Diego Ca 92170
18	Jonathan	Bradley	0 Novick Pass	Dallas	TX	75372		Bradley family	0 Novick Pass, Dallas Tx 75372
19	Annie	Bradley	0 Novick Pass	Dallas	TX	75372		Bradley family	0 Novick Pass, Dallas Tx 75372
20	Timothy	Bradley	0 Novick Pass	Dallas	TX	75372		Bradley family	0 Novick Pass, Dallas Tx 75372
21	Barbara	Spencer	0 Sachs Plaza	Detroit	MI	48232		Barbara Spencer	0 Sachs Plaza, Detroit Mi 48232
22	Amanda	Gomez	0 Spohn Parkway	North Port	FL	34290		Amanda Gomez	0 Spohn Parkway, North Port Fl 34290
23	Billy	Kim	0 Sutteridge Trail	Camden	NJ	8104		Billy Kim & Cheryl Nichols & Jacqueline Rodriguez	0 Sutteridge Trail, Camden Nj 8104
24	Cheryl	Nichols	0 Sutteridge Trail	Camden	NJ	8104		Billy Kim & Cheryl Nichols & Jacqueline Rodriguez	0 Sutteridge Trail, Camden Nj 8104
25	Jacqueline	Rodriguez	0 Sutteridge Trail	Camden	NJ	8104		Billy Kim & Cheryl Nichols & Jacqueline Rodriguez	0 Sutteridge Trail, Camden Nj 8104
26	Antonio	Weaver	00 Lunder Pass	San Diego	CA	92160		Weaver family	00 Lunder Pass, San Diego Ca 92160
27	Dorothy	Weaver	00 Lunder Pass	San Diego	CA	92160		Weaver family	00 Lunder Pass, San Diego Ca 92160
28	Albert	Weaver	00 Lunder Pass	San Diego	CA	92160		Weaver family	00 Lunder Pass, San Diego Ca 92160
29	Jean	Weaver	00 Lunder Pass	San Diego	CA	92160		Weaver family	00 Lunder Pass, San Diego Ca 92160
Sheet1

Cell Formulas
Range	Formula
H2	=AddressTo(A2:F2)
H3	=AddressTo(A3:F3,$A$1:$F$1000)
I2	=AddressFor(A2:F2)
I3	=AddressFor(A3:F3)

 

[Mardy McFly]

Hi live_excel,

Thanks for the reply. Unfortunately, the formula doesn't work quite right. Here is the same table with your formula and what I am looking for a formula or macro to do (sorry, should have put this in on the first post):

[TABLE="width: 1130"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]first_name[/TD]
[TD]last_name[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD] Zip[/TD]
[TD]Formula[/TD]
[TD]Needed[/TD]
[/TR]
[TR]
[TD]Nicholas[/TD]
[TD]Robertson[/TD]
[TD]0 Barnett Circle[/TD]
[TD]Waco[/TD]
[TD]TX[/TD]
[TD]76796[/TD]
[TD]The Robertson family[/TD]
[TD]The Robertson family[/TD]
[/TR]
[TR]
[TD]Benjamin[/TD]
[TD]Robertson[/TD]
[TD]0 Barnett Circle[/TD]
[TD]Waco[/TD]
[TD]TX[/TD]
[TD]76796[/TD]
[TD]The Robertson family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Maria[/TD]
[TD]Woods[/TD]
[TD]0 Bluestem Junction[/TD]
[TD]Mobile[/TD]
[TD]AL[/TD]
[TD]36622[/TD]
[TD]Maria Woods[/TD]
[TD]The Woods Family[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]Kelly[/TD]
[TD]0 Browning Crossing[/TD]
[TD]Pasadena[/TD]
[TD]CA[/TD]
[TD]91199[/TD]
[TD]The Kelly family[/TD]
[TD]Karen Kelly & Theresa Lawrence & Ruby Carter[/TD]
[/TR]
[TR]
[TD]Theresa[/TD]
[TD]Lawrence[/TD]
[TD]0 Browning Crossing[/TD]
[TD]Pasadena[/TD]
[TD]CA[/TD]
[TD]91199[/TD]
[TD]The Lawrence family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ruby[/TD]
[TD]Carter[/TD]
[TD]0 Browning Crossing[/TD]
[TD]Pasadena[/TD]
[TD]CA[/TD]
[TD]91199[/TD]
[TD]The Carter family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Julia[/TD]
[TD]Scott[/TD]
[TD]0 Dorton Trail[/TD]
[TD]Corpus Christi[/TD]
[TD]TX[/TD]
[TD]78465[/TD]
[TD]Julia Scott[/TD]
[TD]The Scott Family[/TD]
[/TR]
[TR]
[TD]Carlos[/TD]
[TD]Black[/TD]
[TD]0 Fairfield Plaza[/TD]
[TD]Las Vegas[/TD]
[TD]NV[/TD]
[TD]89150[/TD]
[TD]The Black family[/TD]
[TD]The Black Family[/TD]
[/TR]
[TR]
[TD]Kathryn[/TD]
[TD]Black[/TD]
[TD]0 Fairfield Plaza[/TD]
[TD]Las Vegas[/TD]
[TD]NV[/TD]
[TD]89150[/TD]
[TD]The Black family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Gerald[/TD]
[TD]Black[/TD]
[TD]0 Fairfield Plaza[/TD]
[TD]Las Vegas[/TD]
[TD]NV[/TD]
[TD]89150[/TD]
[TD]The Black family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Eugene[/TD]
[TD]Hernandez[/TD]
[TD]0 Hanover Plaza[/TD]
[TD]Wilmington[/TD]
[TD]DE[/TD]
[TD]19897[/TD]
[TD]Eugene Hernandez[/TD]
[TD]The Hernandez Family[/TD]
[/TR]
[TR]
[TD]Anne[/TD]
[TD]Ortiz[/TD]
[TD]0 Hoepker Parkway[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD]92110[/TD]
[TD]Anne Ortiz[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Cynthia[/TD]
[TD]Howard[/TD]
[TD]0 Manufacturers Center[/TD]
[TD]San Antonio[/TD]
[TD]TX[/TD]
[TD]78260[/TD]
[TD]The Howard family[/TD]
[TD]Cynthia Howard & Louis Burke[/TD]
[/TR]
[TR]
[TD]Louis[/TD]
[TD]Burke[/TD]
[TD]0 Manufacturers Center[/TD]
[TD]San Antonio[/TD]
[TD]TX[/TD]
[TD]78260[/TD]
[TD]The Burke family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Rachel[/TD]
[TD]Patterson[/TD]
[TD]0 Meadow Valley Avenue[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD]92170[/TD]
[TD]Rachel Patterson[/TD]
[TD]The Patterson Family[/TD]
[/TR]
[TR]
[TD]Jonathan[/TD]
[TD]Bradley[/TD]
[TD]0 Novick Pass[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD]75372[/TD]
[TD]The Bradley family[/TD]
[TD]The Bradley family[/TD]
[/TR]
[TR]
[TD]Annie[/TD]
[TD]Bradley[/TD]
[TD]0 Novick Pass[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD]75372[/TD]
[TD]The Bradley family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Timothy[/TD]
[TD]Bradley[/TD]
[TD]0 Novick Pass[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD]75372[/TD]
[TD]The Bradley family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Barbara[/TD]
[TD]Spencer[/TD]
[TD]0 Sachs Plaza[/TD]
[TD]Detroit[/TD]
[TD]MI[/TD]
[TD]48232[/TD]
[TD]Barbara Spencer[/TD]
[TD]The Spencer Family[/TD]
[/TR]
[TR]
[TD]Amanda[/TD]
[TD]Gomez[/TD]
[TD]0 Spohn Parkway[/TD]
[TD]North Port[/TD]
[TD]FL[/TD]
[TD]34290[/TD]
[TD]Amanda Gomez[/TD]
[TD]The Gomez Family[/TD]
[/TR]
[TR]
[TD]Billy[/TD]
[TD]Kim[/TD]
[TD]0 Sutteridge Trail[/TD]
[TD]Camden[/TD]
[TD]NJ[/TD]
[TD]8104[/TD]
[TD]The Kim family[/TD]
[TD]Billy Kim & Cheryl Nichols & Jacqueline Rodriguez[/TD]
[/TR]
[TR]
[TD]Cheryl[/TD]
[TD]Nichols[/TD]
[TD]0 Sutteridge Trail[/TD]
[TD]Camden[/TD]
[TD]NJ[/TD]
[TD]8104[/TD]
[TD]The Nichols family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jacqueline[/TD]
[TD]Rodriguez[/TD]
[TD]0 Sutteridge Trail[/TD]
[TD]Camden[/TD]
[TD]NJ[/TD]
[TD]8104[/TD]
[TD]The Rodriguez family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Antonio[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD]92160[/TD]
[TD]The Weaver family[/TD]
[TD]The Weaver family[/TD]
[/TR]
[TR]
[TD]Dorothy[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD]92160[/TD]
[TD]The Weaver family[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Albert[/TD]
[TD]Weaver[/TD]
[TD]00 Lunder Pass[/TD]
[TD]San Diego[/TD]
[TD]CA[/TD]
[TD]92160[/TD]
[TD]The Weaver family[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]