How to Merge Two Cells IF Another Cell Matches

S

suzikeith

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
 
J

Jacob Skaria

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
copy>pastespecial>select 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
 
Top