Sunday, January 26, 2014

yogi_From A Table Of Names Addresses And Multiple Years Extract Names And Addresses For Specified year

                                          Google Spreadsheet   Post  #1497
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-26-2014
post by Kft Penzhid (!category-topic/docs/spreadsheets/how-do-i/chrome-browser/bpgodiACCag)
Multiple filtering
I have a sheet named 'Data' like this:

contact namecontact addresscontact date1, yearcontact date2, yearcontact date3, year

I'd like to collect contacts by contact date. IMPORTANT: I have multiple dates in multiple columns to one contact. In case there's multiple dates I need that contact multiple times in my new sheet. For expample filtering the year 2011 I need this list: Joe, Gabe, Gabe. Additionally I need the contact addresses, too.

So I have tried this:


where VMERGE is a script that merges the results of the three FILTER function in one.

But Google puts me an error: #N/A All data ranges must be of equal width!

Any idea?

Could this solve with a single FILTER function called for filter all of my date columns?