Tuesday, June 18, 2013

yogi_Compare Data In Column B With That In Column A And if Not Present Post In Column C And ...

                                          Google Spreadsheet   Post  #1249
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 18, 2013
user EVRoberts (https://productforums.google.com/forum/#!msg/docs/2_qARI3wBfE/0L3yx_pXK8IJ)
Help Comparing Multiple Columns vs a Single Column and creating a list of Uniques
Hi Google Doc'rs, I'm hoping you can help.

I have a Base Column, Column A and I'm trying to compare the other columns to it

A & B find the values that are in B but not in A, post them to column C

A & D find the values that are in D but not in A, post them to column E

A & F find the values that are in F but not in A, post them to Column G

I've tried a couple of formulas to do something similar which you can see in C2 and G2

G2 formula worked but wasn't consistent. When I checked it was falsely reporting some No's and Yes'

Any suggestions?
---
whoops i forgot that part
----------------------------------------------------------------------------------------------------------------------------------------------------