Friday, May 24, 2013

yogi_Cross Check Presence And Absence Of List Items In Associated Specified Lists


                                          Google Spreadsheet   Post  #1209
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 24, 2013
user Sebastian Oberhoff (http://productforums.google.com/forum/?zx=txg71a902ibn#!category-topic/docs/spreadsheets/HRZSHGTDszA)
Create list by cross checking multiple arrays
This seems like a fairly basic question but I've been able to come up with an answer so far.

I have two arrays A and B. I want to create a list of all the entries that appear both in array A and B; neither in A nor B; in A but not B; in B but not A. And maybe the same with more than two arrays, but right now just for two.
---
-------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment