Thursday, August 25, 2011

yogi_Extract Entries That Do Not Match Entries In A Specified Column In Another Sheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
fin.severven said:
The problem:
I want sheet 3 to have lines from sheet 1, that has only those letters in Sheet1!B:B that DO NOT match with letters in Sheet2!A:A.
I guess it could be some combination of Filter and Unique, but could not find the way to do it.
For example:
sheet 1
A B
1 timestamp letter
2 01/01/00 00:00:01 a
3 01/02/00 00:00:01 b
4 01/03/00 00:00:01 c
5 01/03/00 00:00:02 d
Sheet 2
A
1 a
2 b
3 e
Sheet 3 should be
A B
1 01/03/00 00:00:01 c
2 01/03/00 00:00:02 d
Thanks in advance for any help with that.
---------------------------------------------------------