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