Excel VS Google Sheets Differences

		Microsoft Office Forums > Microsoft Excel > Excel
Excel VS Google Sheets Differences

01-12-2023, 05:58 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

There are 2 possible ways:
a) A classic one, like:

Code:

=FILTER(SourceSheetName!A2:D10,(SourceSheetName!A2:A10=H1)*(SourceSheetName!B2:B10=H2))

b) Named Table syntax (you must define the source table as Named one - e.g. naming it as SourceTable, to get it to work):

Code:

=FILTER(SourceTable,(SourceTable[SourceColumnHeader1]=H1)*(SourceTable[SourceColumnHeader2]=H2))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Google sheet formula convert to excel	OriginFarms	Excel	1	12-15-2021 05:19 AM
VBA code to transfer data from Excel To Google sheets	eokwaro	Excel Programming	0	05-17-2021 04:17 AM
vba google search on chrome from excel	mbasith	Excel Programming	5	10-26-2018 06:37 AM
Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets)	gluonman	Excel	8	03-22-2017 08:26 PM
=filter() feature of google sheets not in EXCEL	peter.threepins	Excel	1	07-13-2016 08:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 PM.