Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2023, 05:55 PM
kevinm@1ascent.com kevinm@1ascent.com is offline Excel VS Google Sheets Differences Windows 11 Excel VS Google Sheets Differences Office 2021
Novice
Excel VS Google Sheets Differences
 
Join Date: Jan 2023
Posts: 1
kevinm@1ascent.com is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-10-2023, 01:27 PM
spillerbd spillerbd is offline Excel VS Google Sheets Differences Windows 10 Excel VS Google Sheets Differences Office 2021
Competent Performer
 
Join Date: Jan 2016
Posts: 130
spillerbd is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 01-12-2023, 05:01 AM
Debaser's Avatar
Debaser Debaser is offline Excel VS Google Sheets Differences Windows 10 Excel VS Google Sheets Differences Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

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.
Reply With Quote
  #4  
Old 01-12-2023, 05:58 AM
ArviLaanemets ArviLaanemets is offline Excel VS Google Sheets Differences Windows 8 Excel VS Google Sheets Differences Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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))
Reply With Quote
Reply

Tags
excel vs google sheets

Thread Tools
Display Modes


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
Excel VS Google Sheets Differences =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 04:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft