Google Spreadsheet Post #1497
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-26-2014
post by Kft Penzhid (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/bpgodiACCag)
Multiple filtering
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-26-2014
post by Kft Penzhid (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/bpgodiACCag)
Multiple filtering
I have a sheet named 'Data' like this:
contact name | contact address | contact date1, year | contact date2, year | contact date3, year |
Joe | Budapest | 2007 | 2011 | 2012 |
Gabe | London | 2011 | 2011 | |
Jorgos | Athen | 2012 |
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:
=VMERGE(FILTER(Data!A2:B;Data! C2:C=2011);FILTER(Data!A2:B; Data!D2:D=2011);FILTER(Data! A2:B;Data!E2:E=2011))
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?
Thanks
Z.
--------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment