About 1,708,228 results (3,412 milliseconds)
Query cell with comma separate values, and return multiple values ...
https://support.google.com/docs/thread/79520186/query-cell-with-comma-separate-values-and-return-multiple-values?hl=en Oct 27, 2020 ... I am querying two columns in a spread sheet so when both columns meet a ... same criteria, will list them all, comma separated. The formula ...
VLOOKUP or DGET formula for a cell with multiple values separated ...
https://support.google.com/docs/thread/43988096/vlookup-or-dget-formula-for-a-cell-with-multiple-values-separated-by-a-comma?hl=en May 2, 2020 ... But my "Criteria II" have multiple values in one cell separeted by comma and this is problem for me. Values is seperated by commas because this ...
GoogleSheets: Take data in separate cells and combine into 1 cell ...
https://support.google.com/docs/thread/80623259/googlesheets-take-data-in-separate-cells-and-combine-into-1-cell-separated-by-commas?hl=en Nov 2, 2020 ... GoogleSheets: Take data in separate cells and combine into 1 cell separated by commas.... I'm looking to take a bunch of item numbers (that will ...
Matching and Count an Exact Number with Multiple Numbers ...
https://support.google.com/docs/thread/109038867/matching-and-count-an-exact-number-with-multiple-numbers-separated-by-a-comma-and-by-a-year?hl=en May 7, 2021 ... ... Multiple Numbers Separated by a Comma and by a Year. In sheet6, most cells contain numbers that are separated by commas. In Sheet2, I counted ...
I need a formula that adds all the comma separated numbers in a cell.
https://support.google.com/docs/thread/56394637/i-need-a-formula-that-adds-all-the-comma-separated-numbers-in-a-cell?hl=en Jun 30, 2020 ... Good afternoon, I have a sheet where I created a custom script to be able to select multiple entries for a cell from a dropdown, ...
Vlookup return multiple values vertically, separated by comma ...
https://support.google.com/docs/thread/121123347/vlookup-return-multiple-values-vertically-separated-by-comma?hl=en Aug 13, 2021 ... Is there a formula using vlookup that returns multiple values & separated by comma? I believe I could use JOIN formula to join the results but not sure which ...
How do I create a chart from data in a column separated by commas ...
https://support.google.com/docs/thread/11096953/how-do-i-create-a-chart-from-data-in-a-column-separated-by-commas?hl=en Aug 1, 2019 ... I've sorted the sheet by age group and have created multiple other charts based on age but these are columns with only one answer per cell. Now ...
Split comma lists from a cell into rows - Google Docs Editors ...
https://support.google.com/docs/thread/56269014/split-comma-lists-from-a-cell-into-rows?hl=en Jun 29, 2020 ... This leads to a list with occasionally, multiple dates separated by commas, I want any info following commas to copy itself into a new row so it ...
Multiple Values in one row to input into Pivot Table - Google Docs ...
https://support.google.com/docs/thread/307255196/multiple-values-in-one-row-to-input-into-pivot-table?hl=en Nov 11, 2024 ... The multiple selected values in the drop-downs are comma-separated, even though they may look like two separate values. To use this data in ...
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 ...
Concatenate values from multiple cells in a column to a single cell ...
https://support.google.com/docs/thread/18680205/concatenate-values-from-multiple-cells-in-a-column-to-a-single-cell?hl=en Nov 5, 2019 ... I've added some formulas to your Worksheet2 Column C that concatenates your entries in Sheet1A by ID into one line, separated by comma for each value.
Can I filter based on one value out of many comma separated ...
https://support.google.com/docs/thread/67478857/can-i-filter-based-on-one-value-out-of-many-comma-separated-values?hl=en Aug 27, 2020 ... You can use Data Validation to create a drop-down in a cell that uses a "list of items" of the animals and then use PE Ben's formula but ...
Making charts from multiple survey replies in a single cell - Google ...
https://support.google.com/docs/thread/25229716/making-charts-from-multiple-survey-replies-in-a-single-cell?hl=en Jan 10, 2020 ... collect data back into one column: = ... The important part is that I want each part that is separated by a comma, to be read as different values.
"Filter by Values" with Multiple Tags - Google Docs Editors Community
https://support.google.com/docs/thread/124069548/filter-by-values-with-multiple-tags?hl=en Sep 2, 2021 ... I wanna preface this by saying I have next to no understanding of how Excel ... I just type them in, one at a time and separated by a comma. ~The ...
Formatting ImportJSON data in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/153238654/formatting-importjson-data-in-google-sheets?hl=en Mar 2, 2022 ... At the moment I'm using the following formula which imports values from multiple years into the same cell divided by commas, and the values ...
What is the data validation for range of values seperated by commas ...
https://support.google.com/docs/thread/150247897/what-is-the-data-validation-for-range-of-values-seperated-by-commas?hl=en Feb 10, 2022 ... The data validation allows multiple values to be written in the cell as long as they are within the specified range and are separated by a comma (with or ...
splitting dataset rows based on comma separated values in one ...
https://support.google.com/docs/thread/205336269/splitting-dataset-rows-based-on-comma-separated-values-in-one-column-and-replicating-all-other-colum?hl=en Mar 9, 2023 ... I would like to split the row: separate the multiple values one by row and just replicate all other columns.
Vlookup Sum Comma Separated Values - Google Docs Editors ...
https://support.google.com/docs/thread/111576360/vlookup-sum-comma-separated-values?hl=en May 28, 2021 ... ... one-cell-containing-comma-separated-values. Please help! Here's an ... multiple rows with one formula. I added tab prices2 with a few ...
Google forms results, separate checkbox answers into columns ...
https://support.google.com/docs/thread/52862255/google-forms-results-separate-checkbox-answers-into-columns?hl=en Jun 11, 2020 ... When the survey results come in, I get anything checked all in one cell (say, D2), separated by a comma, D3 would hold the answer to the fill in ...
Changing TEXTSPLIT and GROUP BY to make a VLOOKUP formula ...
https://support.google.com/docs/thread/325102172/changing-textsplit-and-group-by-to-make-a-vlookup-formula-work-in-sheets?hl=en Feb 14, 2025 ... Some of the cells in a column are empty, and some contain multiple values separated by commas. Example datasheet with a mock column is found ...