About 1,534,012 results (3,784 milliseconds)
What is the Google Sheets name for what Excel calls a workbook ...
https://support.google.com/docs/thread/40407678/what-is-the-google-sheets-name-for-what-excel-calls-a-workbook?hl=en Apr 16, 2020 ... Google Sheets is the Cloud application for creating spreadsheets. A Google Spreadsheet is an entire file. Each Sheet in a Google spreadsheet is a tab.
Getting the "calling workbook" for a function proves tricky
https://groups.google.com/g/exceldna/c/2kbBNTwonBw Oct 20, 2016 ... ... worksheet name is part of the sheet name. It relies also on the fact that Excel apparently enforces all worksheets to have different names ...
Filter Question Using Worksheet Tab Name - Google Docs Editors ...
https://support.google.com/docs/thread/173106443/filter-question-using-worksheet-tab-name?hl=en Jul 29, 2022 ... I'm trying to gather and consolidate information from a different worksheet tab, but I want to base the name on what I type into another cell.
Get the active sheet's name to be in a cell - Google Docs Editors ...
https://support.google.com/docs/thread/87383462/get-the-active-sheet-s-name-to-be-in-a-cell?hl=en Dec 7, 2020 ... hopefully this can be done with a formula. I am not familiar with how to run scripts in sheets. I have done it with excel in the past. Details.
Availability of a Workbook ID property similar to Worksheet ID?
https://groups.google.com/g/exceldna/c/Rnt1lBFP-wQ Mar 9, 2021 ... Once I have the calling sheet name, I can get the calling workbook using XlCall.Excel(XlCall.xlfGetDocument, 88, sheetName). workbookName2 won't ...
Using a cell value as worksheet name in an Index Match formula ...
https://support.google.com/docs/thread/182192198/using-a-cell-value-as-worksheet-name-in-an-index-match-formula?hl=en Oct 3, 2022 ... ... sheet name). I cannot figure out any way to make this work in the formula. I am a Google Sheets/Excel novice. I have tried different ...
Error "Unresolved sheet name" when copying tabs from one google ...
https://support.google.com/docs/thread/12478976/error-unresolved-sheet-name-when-copying-tabs-from-one-google-sheets-file-to-another?hl=en Aug 21, 2019 ... I simulated the same thing in Excel, works just fine there, because excel automatically updates/refreshes that. In other words. It's a ...
Renamed a sheet in my workbook and now I have #REF! errors in ...
https://support.google.com/docs/thread/28435571/renamed-a-sheet-in-my-workbook-and-now-i-have-ref-errors-in-other-workbooks-that-were-linked-to-it?hl=en Feb 11, 2020 ... I reference cells in a sheet in workbook A in workbook B, but, unlike Excel ... I could change the name in a worksheet and move around columns/ ...
How can I get Google Sheets to display the name of a named call ...
https://support.google.com/docs/thread/39249028/how-can-i-get-google-sheets-to-display-the-name-of-a-named-call-when-it-is-selected?hl=en Apr 10, 2020 ... Excel has a Name Box field under the ribbon that shows the address or name of the selected range and the contents. If the cell has a name, it is ...
colored box around a cell with my name on a tab at right, how do I ...
https://support.google.com/docs/thread/5281446/colored-box-around-a-cell-with-my-name-on-a-tab-at-right-how-do-i-remove-it?hl=en May 1, 2019 ... I entered information to certain cells inside a schedule template. Somehow, I entered a colored outline and it has my name on a tab to the ...
Lock a sheet name within a formula so that the formula will not ...
https://support.google.com/docs/thread/201235153/lock-a-sheet-name-within-a-formula-so-that-the-formula-will-not-change-if-the-sheet-is-renamed?hl=en Feb 9, 2023 ... My knowledge of excel is purely based on: I know what I want to do, so let me google how to do it. It works, but often has me doing the long ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Google Sheets function list. Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create ...
Lookup Matching Value Across Multiple Worksheets And Return ...
https://support.google.com/docs/thread/43383714/lookup-matching-value-across-multiple-worksheets-and-return-sheet-name?hl=en Apr 29, 2020 ... 'Sheet_List' is a Named Range with all 10 worksheet names (range M2:M11). I pasted that formula on cell L2 and dragged down the column. For some ...
What is the Google Sheets name for what Excel calls a workbook ...
https://support.google.com/docs/thread/40407678?hl=en&msgid=40475428 Apr 16, 2020 ... Google does not refer to the term workbook. Users of Google Sheet sometimes use the term workbook as a way to say the entire spreadsheet file.
How to find unique values and tally them? - Google Docs Editors ...
https://support.google.com/docs/thread/41180423/how-to-find-unique-values-and-tally-them?hl=en Apr 19, 2020 ... I had dozens of people fill out a Google Form nominating up to 10 people each for an award. I now have a spreadsheet with hundreds of names ...
Finding the SUM across multiple tabs based upon a name - Google ...
https://support.google.com/docs/thread/6558040/finding-the-sum-across-multiple-tabs-based-upon-a-name?hl=en May 21, 2019 ... Where might I find a/some good resource(s) for learning about Arrays, ARRAYFORMULA, and QUERY in Sheets (and Excel). These seem like pretty ...
How to rename a TAB based on a cell value? - Google Docs Editors ...
https://support.google.com/docs/thread/5236560/how-to-rename-a-tab-based-on-a-cell-value?hl=en May 1, 2019 ... Automatically rename a googlesheet TAB based on the value of a particular cell say "H2", everytime when the cell value changes.
Unwanted changes to named ranges (the name) when copying a ...
https://support.google.com/docs/thread/94827954/unwanted-changes-to-named-ranges-the-name-when-copying-a-sheet-to-another-workbook?hl=en Jan 23, 2021 ... I have multiple workbooks that have similar formatting. When I copy a sheet from one workbook to another, the named ranges change. Original ...
I need to enter a name into a cell, then the price automatically ...
https://support.google.com/docs/thread/100498123/i-need-to-enter-a-name-into-a-cell-then-the-price-automatically-appears-next-to-it-in-a-sep-cell?hl=en Mar 2, 2021 ... I am trying to create a sheet to automate the process whereby someone enters a numeric value of events, then the price appears next to it.
Need help extracting names from a column - Google Docs Editors ...
https://support.google.com/docs/thread/244639348/need-help-extracting-names-from-a-column?hl=en Nov 19, 2023 ... Your sample spreadsheet is a view-only Microsoft Excel file. If you need more help, please share a Google Sheet with "can edit" rights as ...