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.
---
Here's an example: https://docs.google. com/spreadsheet/ccc?key= 0At0A7q4- kyXLdG1wT0N3SDFMVjRNRDJlUDZxcj hQTGc#gid=0
-------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment