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.
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
https://docs.google.com/
----------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment