http://www.google.com/support/forum/p/Google+Docs/thread?tid=17b0c9636f692c18&hl=en
In cell A5 is the FILTER formula that retrieves the data form the 'Contacts' sheet:
In cell A5 is the FILTER formula that retrieves the data form the 'Contacts' sheet:
=FILTER( 'Contacts'!A2:D ; SEARCH( B1 ; " "&'Contacts'!B2:B&" " ); SEARCH(B2 ; " "&'Contacts'!C2:C&" "); SEARCH( B3 ; " "&'Contacts'!D2:D&" " ) )
=ImportData("https://spreadsheets.google.com/viewform?key=pPbcejygf5gah0jNsqV-lVQ&hl=en" )
=ImportData("https://spreadsheets.google.com/viewform?key=pPbcejygf5gah0jNsqV-lVQ&hl=en" )
Комментариев нет:
Отправить комментарий