About 1,162,715 results (5,818 milliseconds)
How do I locating all spreadsheets that are using (IMPORTRANGE ...
https://support.google.com/docs/thread/153211521/how-do-i-locating-all-spreadsheets-that-are-using-importrange-from-a-specific-sheet?hl=en Mar 2, 2022 ... Similar feature I missed from the excel days is tracing dependents of a cell to find where a formula points to, couldn't find that feature ...
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 trace dependents on Google Sheets? - Google Docs Editors ...
https://support.google.com/docs/thread/239805079/how-to-trace-dependents-on-google-sheets?hl=en Oct 18, 2023 ... Make sure you're searching "All sheets" and "Also search within formulas" is checked ... check to see if your cell appears in any array in your ...
Search and use find and replace - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/62754?hl=en&co=GENIE.Platform%3DDesktop To replace the word every time it's used, click Replace all. Use find and replace in a spreadsheet ... Also search within formulas: Searches include ...
how to determine whether a cell contains a formula
https://groups.google.com/g/exceldna/c/87Qi8Q5sVq4 Oct 5, 2010 ... hi everyone, I started using ExcelDna this weekend, and I can't find any information in the archives related to my question.
Formula to find all occurrences of a value in multiple columns ...
https://support.google.com/docs/thread/42272676/formula-to-find-all-occurrences-of-a-value-in-multiple-columns?hl=en Apr 24, 2020 ... I'd like a formula that searches/queries the entire range, finding every occurrence of a specific name, and summing the values in the adjacent cells.
Find all columns by name/heading? - Google Docs Editors Community
https://support.google.com/docs/thread/129340535/find-all-columns-by-name-heading?hl=en Oct 4, 2021 ... I only try to find this because this is for my friend and she's not well versed with excel/google sheet formulas and I'd like to make it easier ...
How to see formula calculation steps in Google Sheets? - Google ...
https://support.google.com/docs/thread/7547557/how-to-see-formula-calculation-steps-in-google-sheets?hl=en Jun 6, 2019 ... What should be my approach when trying for figure ... Instead, copy the formula to Excel and evaluate it there. Almost all of the formulas work ...
How do I communicate the request for a spreadsheet function ...
https://support.google.com/docs/thread/26771544/how-do-i-communicate-the-request-for-a-spreadsheet-function?hl=en Jan 26, 2020 ... using AppsScript is very annoying, for example i copy the sheet ,script execution permission required every time!!! ( of course I know it's ...
Formulas won't execute automatically after copy/pase - Google Docs ...
https://support.google.com/docs/thread/108993796/formulas-won-t-execute-automatically-after-copy-pase?hl=en May 7, 2021 ... One easy way to refresh all formulas is to use Edit > Find and ... For additional tips on how to copy multiple sheets from one spreadsheet file to ...
Google sheets wont display formula results, I only see the formula in ...
https://support.google.com/docs/thread/2758245/google-sheets-wont-display-formula-results-i-only-see-the-formula-in-the-cell?hl=en Mar 20, 2019 ... The View>Show Formulas is off (not checked). Only the formula ... After searching all over and trying colors, and format reset I read ...
Find and Replace - finds the string but when I want it replaced it says ...
https://support.google.com/docs/thread/39815474/find-and-replace-finds-the-string-but-when-i-want-it-replaced-it-says-that-it-can-t-find-the-strin?hl=en Apr 13, 2020 ... So, this sheet had formulas in every cell. What I just did was take the parsed sheet and copy and paste the VALUES ONLY into a 3rd sheet in the ...
How do I show formulas in Google Sheets when working on an iPad ...
https://support.google.com/docs/thread/138503152/how-do-i-show-formulas-in-google-sheets-when-working-on-an-ipad?hl=en Dec 3, 2021 ... ... formulas" from the view menu. However, I can't seem to find this option in the app on my iPad. Is there a way to show formulas? Note that I ...
How can I trace dependents of a cell? - Google Docs Editors ...
https://support.google.com/docs/thread/201448619/how-can-i-trace-dependents-of-a-cell?hl=en Feb 11, 2023 ... You can use Edit > Find and replace > Also search in formulas to ... all possible ways to refer to a cell, and goes only one level deep ...
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 would like a formula that found any instance of 'TX' in the 'State ... I'm not very familiar with Sheets (or Excel), but in looking I ...
Excel Formulas Not Working in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/219934507/excel-formulas-not-working-in-google-sheets?hl=en Jun 8, 2023 ... I was wondering whether I could get some help with my budget spreadsheet. All of the formulas work perfectly in Excel but I am getting a ton of ...
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 would like to find all the unique names, list them, then count how many times they appear in the FormResponses.
How to Detect Cells that Failed Data Validation - Google Docs ...
https://support.google.com/docs/thread/174285217/how-to-detect-cells-that-failed-data-validation?hl=en Aug 8, 2022 ... The easiest solution would probably be to insert a helper column where you have a formula that shows a true/false value based on the same logic that you use in ...
Why does my formula bar disappear?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/gPDqWNHdT7I Nov 10, 2001 ... I have used every version of Excel since it was first released and have never had a problem like this. For no reason I can identify, when I
Formulas not recognizing a certain column?!??? - Google Docs ...
https://support.google.com/docs/thread/58448228/formulas-not-recognizing-a-certain-column?hl=en Jul 11, 2020 ... 1. The monthly tabs auto find the balance when any numbers are entered but when it copies the info to OCMT, Events, Cookies, or any troop tabs the numbers in ...