Saturday, February 12, 2011

yogi_MergingDataFromDifferentSpreadsheets


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com




MyList

CompanyList
Nathanael Emenaker said ...
"I want to be able to merge both of these lists and remove the duplicate names, so that the all my information remains, but the new names, the customers I have not contacted, are integrated into my list"
---------------------------------------------
in the solution presented in the following spreadsheet, I have used some intermediary calcs shown in gray colored text in the columns to the right