Search for same text in column D and find...
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street

=IF(AND(D1="Mel Rosenfeld", D2="Mel Rosenfeld", D3="Mel Rosenfeld"), A1 & ",
" & A2 & ", " & A3, "")

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mel" wrote in message
...
Search for same text in column D and find...
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street

Thank you Rob...two questions...
Which cell do I put this formula in and will this work for 15,000 cells? I
have a sheet and wish to make it a template where I can import other data
daily into this template so that it will automatically use these formulas so
that I don't have to imput the formulas for each sheet...hope this makes
sense...

Thanks again!

"Rob van Gelder" wrote:

=IF(AND(D1="Mel Rosenfeld", D2="Mel Rosenfeld", D3="Mel Rosenfeld"), A1 & ",
" & A2 & ", " & A3, "")

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mel" wrote in message
...
Search for same text in column D and find...
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street

Hi again...

I need this to search the entire column and find names that are exactly the
same in column D...could be two cells could be 5+, then I need to go to
column A to the corresponding cell numbers and take the addresses and
concatenate all of the corresponding addresses into the first cell of
corresponding addresses. Need this for 15,000(+/-) cells per column...trying
to create a template so that when I have another database imported it will
automatically use these formulas...

Any sense? Can this be done...there must be a way...

Thanks again!

"Rob van Gelder" wrote:

=IF(AND(D1="Mel Rosenfeld", D2="Mel Rosenfeld", D3="Mel Rosenfeld"), A1 & ",
" & A2 & ", " & A3, "")

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mel" wrote in message
...
Search for same text in column D and find...
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street