Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
HELP!!!
I have been trying and trying...but no luck. Here is the issue.. I have in column D a name and in column E a name and in column A and address. Now...in either column D or E there could be several instances where the name appear several times. Keeping in mind that I have about 15,000 rows to search/find. D E A name1 name4 address1 name1 name4 address2 name1 name4 address3 name1 name4 address4 name2 name5 address5 name2 name5 address6 name3, etc. name6, etc. address7, etc. What I need to do is search column E for exact same name, search column D for another name which will be different than the name in column E but will have the same exact number of same name as in column D. Once the search is complete I need to go to column A take those addresses in the same rows as the same names and concatenate them into the first row where the first address cell appears. D E A name1 name4 address1, address2, address3, address4 name1 name4 name1 name4 name1 name4 name2 name5 address5, address6 name2 name5 name3, etc. name6, etc. address7, etc. These would all be real names and address and not name1, etc. that I am working with. PLEASE HELP....THERE HAS TO BE A WAY!!! THANK YOU VEYR MUCH!!!! |