Saturday, April 12, 2014

yogi_Rewrite Names Such That If A Name Exists In NameB Don't Show In NameA


                                         Google Spreadsheet   Post  #1600
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-12-2014
post by BenGW (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/qjOraRebzDY)
How to compare columns, delete duplicates?
Here's a link to a sample sheet similar to the one I'm working with:
https://docs.google.com/spreadsheet/ccc?key=0AvdLrfw-05bsdEdGTWxxZ0htcnpFVTlGYW1wRm9zRnc&usp=sharing


I would like to be able to do the following:
1.  Compare two columns (A and B)
2.  Find duplicate entries in the two columns
3.  Delete the duplicates in one column but not the other.

Ultimately, in the sheet like my sample shown above, I need to compare A to B, and delete any entries in A that also appear in B. Then I need to compare B to C, and delete any entries in B that also appear in C. But I'm going to have to be doing a lot of this sort of thing, so I really just need to know how to compare two columns and delete entries in one that also appear in the other.

Thank you for any guidance you may offer.

B

--------------------------------------------------------------------------------------------------------------------------------------------------

in the following solution, in the rewritten columns matching names in rewritten NameA column are not deleted ... display of those names is suppressed -- it is a dynamic setup