Wednesday, June 12, 2013

yogi_Extract Those records From Sheet Log Where Column C Does Not Equal Those Present In Column B Of Sheet Omit

                                          Google Spreadsheet   Post  #1239
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 12, 2013
user Stani NS (http://productforums.google.com/forum/?zx=1h3b252x1hx5#!mydiscussions/docs/7GA2aqPlGrs)
How do I filter using range of cells input?
How do I FILTER?

=FILTER( Log!B2:H , Log!F2:F <> Omit!B2:B )

I tried this, but result was not proper.....Pls Help!!
---
Hi

Here is the link:
------------------------------------------------------------------------------------------------------------------------------------------