About 1,027,801 results (3,412 milliseconds)
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category.
How to list all staff names that are contained in a list - Google Docs ...
https://support.google.com/docs/thread/82348915/how-to-list-all-staff-names-that-are-contained-in-a-list?hl=en Nov 11, 2020 ... Here the ArrayFormula function is only doing the TextJoin for all of the query results. I hope this helps. If not, please share a sample sheet ...
Sheets equivalent formulas from Excel - Google Docs Editors ...
https://support.google.com/docs/thread/12367026/sheets-equivalent-formulas-from-excel?hl=en Aug 19, 2019 ... that said, i know know there's some additional reference going on too, for example, Homework used to be the name of the Milestones List tab, but ...
How to conditional format based on a list of names - Google Docs ...
https://support.google.com/docs/thread/45427579/how-to-conditional-format-based-on-a-list-of-names?hl=en May 8, 2020 ... I have attached a sample file below so you can see. Whatever ... Custom Formula is... Formula: =MATCH(C2,$A$2:$A,0). Format: <format ...
Set up conditional formatting that is also case sensitive - Google ...
https://support.google.com/docs/thread/225325361/set-up-conditional-formatting-that-is-also-case-sensitive?hl=en Jul 13, 2023 ... I will create an example in your spreadsheet to demonstrate the Valid Name List and the formula for the Rates tab. My formula will read the ...
SHEETS: How to reference the Text/Value from one cell within a ...
https://support.google.com/docs/thread/137041108/sheets-how-to-reference-the-text-value-from-one-cell-within-a-formula-of-another-cell?hl=en Nov 24, 2021 ... ... list of names, each name on a different row. Within that row is a number of formulas referencing a SHEET with that corresponding name. So ...
How can I extract a student list by prof in this example? - Google ...
https://support.google.com/docs/thread/102622538/how-can-i-extract-a-student-list-by-prof-in-this-example?hl=en Mar 17, 2021 ... A formula in i2 (green) gathers the Student IDs, their courses and professor names from all 3 column-pairs, and returns the list of students who ...
Create & use named functions - Google Docs Editors Help
https://support.google.com/docs/answer/12504534?hl=en Create a named function · Placeholders are descriptions of the type of inputs the function expects. For example, argument names “ CELL '' or “ RANGE ” are for ...
What function can I use to count the number of models sold for one ...
https://support.google.com/docs/thread/3101320/what-function-can-i-use-to-count-the-number-of-models-sold-for-one-manufacturer?hl=en Mar 27, 2019 ... I am trying to use the COUNTIFS function using a list of ... In the test spreadsheet below, an example would be counting in cell ...
Custom Functions in Google Sheets | Apps Script | Google for ...
https://developers.google.com/apps-script/guides/sheets/functions Type an equals sign ( = ) followed by the function name and any input value — for example, =DOUBLE(A1) — and press Enter. The cell will momentarily display ...
Replace Text with Exact Text if it Contains Target Text - Google Docs ...
https://support.google.com/docs/thread/180678307/replace-text-with-exact-text-if-it-contains-target-text?hl=en Sep 23, 2022 ... I'm wondering if there's a way to take the names that they submit in one tab and use a formula to compare those names to our list of exact names.
Trying to replace a list of numbers with another list of numbers ...
https://support.google.com/docs/thread/127316963/trying-to-replace-a-list-of-numbers-with-another-list-of-numbers-basically-replace-all-but-in-bulk?hl=en Sep 22, 2021 ... Is there a setup or formula solution for this? Happy to receive any guidance! EDITED: Sheet 1 is a Reference Sheet with Names connected with an ...
Nested Lookup Formula Across Multiple Excel Sheets - Google ...
https://support.google.com/docs/thread/273069198/nested-lookup-formula-across-multiple-excel-sheets?hl=en May 6, 2024 ... In sheet "customer" there is a list with customer name and numbers ... Thank you for sharing a sample spreadsheet. Try something like ...
Distinct Drop Down in multiple rows AND columns? - Google Docs ...
https://support.google.com/docs/thread/134303955/distinct-drop-down-in-multiple-rows-and-columns?hl=en Nov 7, 2021 ... On the Participants sheet, I used the following formula to list the names that have not been assigned: = ... Examples of this can be found ...
Formula for a list of names from a rota sorted by shift type. - Google ...
https://support.google.com/docs/thread/35723619/formula-for-a-list-of-names-from-a-rota-sorted-by-shift-type?hl=en Mar 26, 2020 ... Apologies...link is an example of the problem. Staff number is text ikn my version if that makes a difference! https://docs.
Checkbox, when checked also checks other boxes that has same ...
https://support.google.com/docs/thread/26755062/checkbox-when-checked-also-checks-other-boxes-that-has-same-name-next-to-them?hl=en Jan 26, 2020 ... In your example, it's fine if the list of names is generated with formulas or the user. What won't work is the columns with the checkboxes ...
How to get selected drop down list items to remove themselves from ...
https://support.google.com/docs/thread/77638549/how-to-get-selected-drop-down-list-items-to-remove-themselves-from-a-master-list-not-the-drop-list?hl=en Oct 18, 2020 ... Along with the 25 blank cells with dropdowns, I have a master list of every employees name that is simple text in cells. ... the formula to get ...
Need a way to give a specific list filtering teacher name based on ...
https://support.google.com/docs/thread/102380885/need-a-way-to-give-a-specific-list-filtering-teacher-name-based-on-new-data-data-changes-daily?hl=en Mar 15, 2021 ... Here's a sample of the spreadsheet. Details. Sheets,Microsoft Windows ... I put a formula to number the students in the list. See B4 ...
How to Check and Compare Sheet names to an array- or list ...
https://support.google.com/docs/thread/97739530/how-to-check-and-compare-sheet-names-to-an-array-or-list?hl=en Feb 11, 2021 ... This works fine, but the problem is that the formula does not automatically refresh when a sheet name is changed. I figured the best solution ...
How can I format text to be a different color if that text does not ...
https://support.google.com/docs/thread/75260108/how-can-i-format-text-to-be-a-different-color-if-that-text-does-not-appear-in-a-list?hl=en Oct 6, 2020 ... I've attached an example sheet explaining exactly what I'm looking for. I have a list of names on the left, and then the column on the right to ...