About 1,692,412 results (2,916 milliseconds)
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 ... ... names. In this example, the names I want to tally are in FormResponses1, columns C-J. I'm trying to create the unique list in sheet 2 (Tally) ...
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.
Need help for budgeting sheet: Summing up cells based on drop ...
https://support.google.com/docs/thread/26208436/need-help-for-budgeting-sheet-summing-up-cells-based-on-drop-down-menu-selection?hl=en Jan 20, 2020 ... Hi Georg,. What you need to use is the SUMIF function. You can check it here : https://support.google.com/docs/answer/ ...
I am trying to find a formula that will search for information and ...
https://support.google.com/docs/thread/91993080/i-am-trying-to-find-a-formula-that-will-search-for-information-and-transfer-it-to-a-new-sheet?hl=en Jan 4, 2021 ... I'm not very familiar with Sheets (or Excel), but in looking I think ... names of your tabs or the location of the State info in your data.
Is there a good way to organize the hidden sheets so they're easier ...
https://support.google.com/docs/thread/121657530/is-there-a-good-way-to-organize-the-hidden-sheets-so-they-re-easier-to-find-navigate-from-the-tab?hl=en Aug 17, 2021 ... Hi Christine,. You are probably referring to the View > Hidden sheets dialog box. The list there shows the hidden sheets in the order they ...
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 ... • If you had a Sheets problem, leave your demo sheet shared as View Only as part of this solution's archive,. • Click Recommend on the post ...
I can't paste a list of items into the data validation box anymore ...
https://support.google.com/docs/thread/199098132/i-can-t-paste-a-list-of-items-into-the-data-validation-box-anymore?hl=en Jan 26, 2023 ... I find it very inconvenient to have to enter each option separately. One suggestion: Somewhere in your sheet, list items you would like to ...
How to pull data from multiple drop-down lists to find most frequent ...
https://support.google.com/docs/thread/183131679/how-to-pull-data-from-multiple-drop-down-lists-to-find-most-frequent-choices-to-least-frequent?hl=en Oct 9, 2022 ... I'm a novice sheets user looking for help. I've created a simple list using data validation with items in a cell. I've repeated this list ...
Google Sheets Count If formula works on it's own but not in an Array ...
https://support.google.com/docs/thread/81411630/google-sheets-count-if-formula-works-on-it-s-own-but-not-in-an-array?hl=en Nov 6, 2020 ... I'm pretty good with excel/google sheets formulas ... So you want the list IDs concatenated with their sequential count/number in the list.
How to create a formula listing duplicate values in a new column ...
https://support.google.com/docs/thread/4456931/how-to-create-a-formula-listing-duplicate-values-in-a-new-column?hl=en Apr 18, 2019 ... I can do simple countifs to find which ones are duplicates, but am failing to create a list of duplicates. I tried to use the formulas in this ...
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 ... I think that may be outside the realm of what sheet formulas can accomplish, unless maybe I can chain OR conditions in the formula to check for ...
Is it possible to sort a column by a list? - Google Docs Editors ...
https://support.google.com/docs/thread/38186467/is-it-possible-to-sort-a-column-by-a-list?hl=en Apr 5, 2020 ... Your sheet is VIEW ONLY, so we can't do any work on it. Sorting by one column (Type) and then an other second column is fairly straight forward.
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 ... ... excel- that now need to be ported over to google sheets (and kept uniform), with 10s of pages of data stored in ranges that are not contiguous.
Google Sheets: Find and replace/delete many values at once ...
https://support.google.com/docs/thread/125735942/google-sheets-find-and-replace-delete-many-values-at-once?hl=en Sep 13, 2021 ... I have a list of contacts in google sheets. In Column A I have Names and in Column B I have associated email address(es).
Formula to find number of times name has been entered into ...
https://support.google.com/docs/thread/119692475/formula-to-find-number-of-times-name-has-been-entered-into-multiple-sheets?hl=en Aug 2, 2021 ... In order to do this, I have had to add a custom formula to your sheet that will collect all of the names of the sheets/tabs that appear in the ...
Conditional formating with Datavalidation list from second sheet ...
https://support.google.com/docs/thread/49447377/conditional-formating-with-datavalidation-list-from-second-sheet?hl=en May 27, 2020 ... I have managed to use Conditional formatting to check which cell i take my data from, and assign a fill color to the new cell accordingly, but this is only in ...
I can't see my tabs at bottom of google spreadsheet. - Google Docs ...
https://support.google.com/docs/thread/7038348/i-can-t-see-my-tabs-at-bottom-of-google-spreadsheet?hl=en May 29, 2019 ... But, I noticed it in Google Sheets because the bottom of Google sheets (or Excel for that matter) are too important to allow to be covered. So ...
Get all items in one list 2 missing in List 1 - Google Docs Editors ...
https://support.google.com/docs/thread/151896576/get-all-items-in-one-list-2-missing-in-list-1?hl=en Feb 22, 2022 ... I am looking for a solution to have the list of items not present in the first list that i would like to find in column F in this GSheet.
Reflecting data from a dropdown list in Sheets - Google Docs Editors ...
https://support.google.com/docs/thread/265363556/reflecting-data-from-a-dropdown-list-in-sheets?hl=en Mar 22, 2024 ... I'm a novice at best in Excel/Sheets. I know basic functionality ... IMPORTANT: Read the Tips post above, then check your sharing ...
How do I get the item i check off on my check list to move to the ...
https://support.google.com/docs/thread/198027340/how-do-i-get-the-item-i-check-off-on-my-check-list-to-move-to-the-bottom-once-checkd-off?hl=en Jan 19, 2023 ... yet to try anything, not sure if it is possible. we are using google docs for a task tracking in our small office and it would be very ...