#1
|
|||
|
|||
Excel VS Google Sheets Differences
Hello,
I am an intermediate user of Google Sheets trying to get a basic understanding of how Excel is different. Every time I try to do a function in Excel it seems to not like what I write. There is plenty of posting out there about which is better. I am not interested in what is better rather what are the fundamental differences in formula syntax etc, that I need to know in order to use excel. Examples. In google sheets i use the FILTER function regularly. In excel i can get it to filter data on the same sheet or tab but once I move to a different tab i cannot seem to figure out how excel wants the other sheet/tab referenced in the formula? I have tried multiple times to get to know excel and every time end up feeling frustrated. If someone out there with a lot knowledge of both platforms could provide a video detailing the fundamental differences it would make a world of difference to those of us who are interested in learning and using excel more. |
#2
|
|||
|
|||
Create or change a cell reference - Microsoft Support
Make sure to read the detailed notes, such as concerns for complex sheet names may require being placed within single quotation marks. https://www.youtube.com/watch?v=GnoS...94epMaX_Y8Tu1k The best YouTube source on Excel is Mike Girvin. The only problem with his YouTube is the quantity an organization issues. However, the linked video can help with both finding the best playlist and his accompanying materials. |
#3
|
||||
|
||||
The simplest way of figuring out the referencing for a range is to select it when writing the formula, as that will build the reference for you.
|
#4
|
|||
|
|||
There are 2 possible ways:
a) A classic one, like: Code:
=FILTER(SourceSheetName!A2:D10,(SourceSheetName!A2:A10=H1)*(SourceSheetName!B2:B10=H2)) Code:
=FILTER(SourceTable,(SourceTable[SourceColumnHeader1]=H1)*(SourceTable[SourceColumnHeader2]=H2)) |
Tags |
excel vs google sheets |
|
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 |