About 1,500,647 results (5,835 milliseconds)
How can I search for a value in an array and extract the value from ...
https://support.google.com/docs/thread/44672602/how-can-i-search-for-a-value-in-an-array-and-extract-the-value-from-the-cell-next-to-it?hl=en May 5, 2020 ... It should be clear from the example sheet. VLOOKUP and doesn't work because the column to return is dependent on which column the value is found ...
How to Extract Unique Values within a range, returning those values ...
https://support.google.com/docs/thread/38541975/how-to-extract-unique-values-within-a-range-returning-those-values-into-a-single-cell?hl=en Apr 8, 2020 ... I actually was able to solve it at one point but I couldn't get rid of the duplicates for every cell, instead I got an error. I need Column M " ...
Extract specific information from a cell to multiple cells - Google ...
https://support.google.com/docs/thread/117452947/extract-specific-information-from-a-cell-to-multiple-cells?hl=en Jul 16, 2021 ... An arrayformula() wrapper lets you evaluate a formula over a range of cells rather than a single cell, returning multiple results automatically.
How to search and extract a single value from a comma separated ...
https://support.google.com/docs/thread/96850498/how-to-search-and-extract-a-single-value-from-a-comma-separated-string-into-another-cell?hl=en Feb 5, 2021 ... I have a column with comma separated text values I'd like to search for and return the same value in another cell. I've tried using LOOKUP, MATCH, and various ...
Extract the edit history of a range of cells as a data table - Google ...
https://support.google.com/docs/thread/198575113/extract-the-edit-history-of-a-range-of-cells-as-a-data-table?hl=en Jan 23, 2023 ... Unfortunately, this is not possible to automate; however, there is a feature request for this that is currently assigned to a Google Dev. You ...
Extracting multiple numbers around a delimiter - Google Docs ...
https://support.google.com/docs/thread/44964278/extracting-multiple-numbers-around-a-delimiter?hl=en May 6, 2020 ... I receive data from one of my reports where a fuel transaction string of text is delivered in a single cell, looking like 000008 C01659253 03/28 ...
Extract data from smart chips in your Google Sheets - Google Docs ...
https://support.google.com/docs/answer/13524011?hl=en Jan 25, 2023 ... Right click on the cell or cells and then Data extraction . Dataextraction. Click Data > Data extraction . Under “Data to extract,” select the ...
Using IMPORTRANGE with multiple sheets and trying to extract ...
https://support.google.com/docs/thread/7533064/using-importrange-with-multiple-sheets-and-trying-to-extract-same-cell-values?hl=en Jun 6, 2019 ... Need some expertise! Goal: extract values from same cells across multiple (175 roughly) google sheets (these sheets were generated from a master ...
How to extract values from cells with array formula - Google Docs ...
https://support.google.com/docs/thread/55204719/how-to-extract-values-from-cells-with-array-formula?hl=en Jun 23, 2020 ... How to extract values from cells with array formula. Hi all,. I'm trying to extract values from a cell into smaller chunks. (Here is my ...
Extract value from csv style to column in 1 formula - Google Docs ...
https://support.google.com/docs/thread/201891299/extract-value-from-csv-style-to-column-in-1-formula?hl=en Feb 14, 2023 ... Extract value from csv style to column in 1 formula · var=value;var2=value2;var3=value3 · I created a column for each key and, for one entry, ...
Extracting a Phrase based on Keywords
https://groups.google.com/g/openrefine/c/XIfKTL6sv0w You can then use OpenRefine faceting and clustering on this column to clean up the data and make sure you have consistent naming of universities etc. Ettore ...
Failed to extract value from XML - help!! - Google Docs Editors ...
https://support.google.com/docs/thread/166163352/failed-to-extract-value-from-xml-help?hl=en Jun 6, 2022 ... I have been trying to extract the returned number "420" from the above XML file into a cell in my Google Sheet but kept failing.
How to extract repeated values in a cell to different columns and ...
https://support.google.com/docs/thread/89294872/how-to-extract-repeated-values-in-a-cell-to-different-columns-and-rows-accordingly?hl=en Dec 18, 2020 ... I would like to make sure I can split the 'lb.' values into multiple rows. At the same, repeating the columns next to them as well.
Trying to Extract Keywords from one Data Set based on another ...
https://support.google.com/docs/thread/180453096/trying-to-extract-keywords-from-one-data-set-based-on-another-data-set?hl=en Sep 22, 2022 ... ... text in the cell that I am trying to lookup. Help!! Please!! :) I am very novice when it comes to formulas and still learning how all of ...
How to get only the number from a cell in a formula - Google Docs ...
https://support.google.com/docs/thread/156228858/how-to-get-only-the-number-from-a-cell-in-a-formula?hl=en Mar 21, 2022 ... I wrongly guessed that you require extracting numbers from the text in cell A1. You are just required to format the formula cell (here C1) ...
How do I extract a string portion of a formula in a cell? - Google Docs ...
https://support.google.com/docs/thread/28640624/how-do-i-extract-a-string-portion-of-a-formula-in-a-cell?hl=en Feb 13, 2020 ... $A5 , which gets the A5 cell value from "Name(Number 4)" tab in the same spreadsheet. I need to extract "4" in the formula string for this cell ...
Formula for "remaining cost" dictated by separate column? - Google ...
https://support.google.com/docs/thread/89066557/formula-for-remaining-cost-dictated-by-separate-column?hl=en Dec 17, 2020 ... FILTER will extract data based on a condition. For this one, FILTER will extract values from column D (D4:D7) whenever there is a "Y" in column ...
extracting data from non static cell, containing numbers and letters ...
https://support.google.com/docs/thread/286978204/extracting-data-from-non-static-cell-containing-numbers-and-letters?hl=en Jul 24, 2024 ... Hope this helps! Original Poster MoRale marked this as an answer. Helpful? 1. Upvote. Downvote. View conversation. All Replies (2). Y. Yogi ...
Extract Numbers from Text and SUM It in Google Sheets - Google ...
https://support.google.com/docs/thread/68911960/extract-numbers-from-text-and-sum-it-in-google-sheets?hl=en Sep 3, 2020 ... I've an following data in one cell (loaded from another system). Can you please help me how can I get an pcs from every row in cell an sum it together?
Extract all rows from a range that meet criteria in one column ...
https://support.google.com/docs/thread/58361932/extract-all-rows-from-a-range-that-meet-criteria-in-one-column?hl=en Jul 11, 2020 ... I have a list with x number of rows, and I would like to collect the rows with value into a new compressed list.