I am trying to combine 2 columns of cells into 1 column of cells. Some of the cells in the 2 columns have blanks and some have duplicate contractor names. I want to remove the duplicate names when combining the 2 cells.
If the new column of cells has duplicates down the column that is ok, infact I don't want to eliminate the duplicates down the cell so contract ACME can appear hundreds of times and that is ok, just don't want the new column of cells to have ACMEACME in any of the cells.
Thanks!
=a1& if(b1=a1,"",b1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
This fits your example
=if(a2<>"",a2,b2)
BUT can you have "John" (a2) and "Smith" (b2)?
=IF(A2<>"",IF(A2=B2,A2,A2&B2),B2)
Awesome! Thank you!
@chemist ..like it .. much neater than mine!
Plus a damn fool question I asked ! Why else would you concatenate ??!!!
Last edited by JohnTopley; 07-10-2015 at 02:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks