I want to Merge "First Names" when the "Address" is the same in each row.
Such that I could end up with "Mary and Joe" in the First Name Field when the
Addresses matched.
Is there a simple way to do this?
Thanks!
Susanne

Room Teacher First Name Last Name Address
23 Bhatnagar Mary Smith 10010 S Stelling Rd
6 Rucker Joe Smith 10010 S Stelling Rd
9 Wiitala Jane Dogma 10015 Orange Av
19 Renaghan Phill Krissy 1002 Westlynn Wy, 4
1 Bunya Darla Krissy 1002 Westlynn Wy, 4
27 Jung Mike Reddy 10021 Carmona Ct
10 Eller Peter Lei 10035 Byrne Av
17 Sanchez Andrew Bertrand 10055 Byrne Av
21 DeSagun April Tsao 10056 Pasadena Av, D
11 Lowe June Grewal 10057 Imperial Av
27 Jung May Keddia 1006 Westlynn Wy, 1
21 DeSagun Frank Keddia 1006 Westlynn Wy, 1

try this in cell F3:
=IF(E3=E2,C2&" and "&C3&" "&D3,"")

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"suzikeith" wrote:

I want to Merge "First Names" when the "Address" is the same in each row.
Such that I could end up with "Mary and Joe" in the First Name Field when the
Addresses matched.
Is there a simple way to do this?
Thanks!
Susanne

Room Teacher First Name Last Name Address
23 Bhatnagar Mary Smith 10010 S Stelling Rd
6 Rucker Joe Smith 10010 S Stelling Rd
9 Wiitala Jane Dogma 10015 Orange Av
19 Renaghan Phill Krissy 1002 Westlynn Wy, 4
1 Bunya Darla Krissy 1002 Westlynn Wy, 4
27 Jung Mike Reddy 10021 Carmona Ct
10 Eller Peter Lei 10035 Byrne Av
17 Sanchez Andrew Bertrand 10055 Byrne Av
21 DeSagun April Tsao 10056 Pasadena Av, D
11 Lowe June Grewal 10057 Imperial Av
27 Jung May Keddia 1006 Westlynn Wy, 1
21 DeSagun Frank Keddia 1006 Westlynn Wy, 1

If you are sure there are not more than 2 entries with the same address you
can try the below formula in F2 and copy down as required...Once done you can
copypastespecialselect values to convert the formulas to actual text.

With data in ColA to ColE and row1 having headers..and F1 a blank cell; try
the below formula in F2.
=IF(F1<"","",IF(E2=E3,C2&" and "&C3,C2))

If this post helps click Yes
---------------
Jacob Skaria


"suzikeith" wrote:

I want to Merge "First Names" when the "Address" is the same in each row.
Such that I could end up with "Mary and Joe" in the First Name Field when the
Addresses matched.
Is there a simple way to do this?
Thanks!
Susanne

Room Teacher First Name Last Name Address
23 Bhatnagar Mary Smith 10010 S Stelling Rd
6 Rucker Joe Smith 10010 S Stelling Rd
9 Wiitala Jane Dogma 10015 Orange Av
19 Renaghan Phill Krissy 1002 Westlynn Wy, 4
1 Bunya Darla Krissy 1002 Westlynn Wy, 4
27 Jung Mike Reddy 10021 Carmona Ct
10 Eller Peter Lei 10035 Byrne Av
17 Sanchez Andrew Bertrand 10055 Byrne Av
21 DeSagun April Tsao 10056 Pasadena Av, D
11 Lowe June Grewal 10057 Imperial Av
27 Jung May Keddia 1006 Westlynn Wy, 1
21 DeSagun Frank Keddia 1006 Westlynn Wy, 1