About 1,206,649 results (1,473 milliseconds)
Can you enter multiple data in one cell and parse them separately ...
https://support.google.com/docs/thread/7671180/can-you-enter-multiple-data-in-one-cell-and-parse-them-separately-when-referencing-the-cell?hl=en Jun 8, 2019 ... The idea is to have multiple data points per cell (if easily possible) which can then be parsed by formulas referencing said cells so we can tally points over ...
Separating the lines of data in a cell to individual rows? - Google ...
https://support.google.com/docs/thread/4839994/separating-the-lines-of-data-in-a-cell-to-individual-rows?hl=en Apr 24, 2019 ... The problem is the actually customer details are in one cell and I need to separate the following 5 lines in separate columns. 47321. Charlotte ...
Formula question - Cell text dependent on 3 separate True/False ...
https://support.google.com/docs/thread/20726612/formula-question-cell-text-dependent-on-3-separate-true-false-cell-values?hl=en Nov 21, 2019 ... I have three cells that can have a value only of either TRUE or FALSE (checkbox). I would like a separate cell to display different text based on the breakdown ...
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 set criteria, will return a company name as a result and if more than one company ...
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 ... ... numbers in another cell (on the same tab) separated by a comma and space. I've worked out a basic formula, but my problem has been not ...
Having multiple values in one cell - Google Docs Editors Community
https://support.google.com/docs/thread/265682904/having-multiple-values-in-one-cell?hl=en Mar 24, 2024 ... ... separate values within one cell? Thank you! Details. Sheets,Chrome OS,Personal use. Locked. Informational notification. This question is locked ...
split numbers in a single cell into separate cells - Google Docs ...
https://support.google.com/docs/thread/129067005/split-numbers-in-a-single-cell-into-separate-cells?hl=en Oct 3, 2021 ... Trying to split numbers in a single cell into multiple cells. The data is currency that I need to transfer into a deposit slip that I want to auto populate ...
Copying color scale conditional formatting over separate cell ranges ...
https://support.google.com/docs/thread/96396170/copying-color-scale-conditional-formatting-over-separate-cell-ranges?hl=en Feb 2, 2021 ... However, when I copy the conditional formatting from the first range, it uses the min/max values of ALL the distinct ranges rather than of EACH.
google sheets, need to separate data from cells into new cells ...
https://support.google.com/docs/thread/138984708/google-sheets-need-to-separate-data-from-cells-into-new-cells?hl=en Dec 6, 2021 ... Are you planning on using an .xlsx file for this? Your sample file is an Excel file.
Array Formula to split cell containing multiple values into separate ...
https://support.google.com/docs/thread/195107817/array-formula-to-split-cell-containing-multiple-values-into-separate-rows?hl=en Dec 30, 2022 ... I am trying to use an array formula to split the cell into separate rows that I borrowed from a solution to a similar problem on here.
How can I calculate values in cells which have linebreaks? - Google ...
https://support.google.com/docs/thread/6260484/how-can-i-calculate-values-in-cells-which-have-linebreaks?hl=en May 16, 2019 ... How can I add all values in a cell together with other cells to get a value that I can work with? like =sum(C3+D3+E3+F3) while each cell has ...
How to link a sheet to a cell in a separate sheet so that sorting the ...
https://support.google.com/docs/thread/183552088/how-to-link-a-sheet-to-a-cell-in-a-separate-sheet-so-that-sorting-the-sheet-doesn-t-change-the-data?hl=en Oct 13, 2022 ... Formulas reference to cells, not to data, this is the same as in Excel. When you use the $ sign, this especially locks the cell so if the ...
How can I separate, $ Value, letters, and date, in one cell. into 3 ...
https://support.google.com/docs/thread/28738437/how-can-i-separate-value-letters-and-date-in-one-cell-into-3-separate-cells?hl=en Feb 14, 2020 ... ... separate cells show $$$$, text, and then date. I know there's a formula for excel but I can't find any info for google sheets. also I know excel ...
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... Is there a way to do this without typing the whole formula? What I mean is, say I have document A and B in Excel. If I want to copy a value in a ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop Split data into columns · If the data's already in the sheet, select the cells you want to split. · If the data isn't in the sheet yet, paste it.
Visualising multiple "locations" in ONE cell on the map chart, how is ...
https://support.google.com/docs/thread/95705970/visualising-multiple-locations-in-one-cell-on-the-map-chart-how-is-this-possible?hl=en Jan 29, 2021 ... But these locations are pulled from another sheet where the "location" values are in ONE cell ( i can't put in separate cells as each row ...
Copy a cell value into a specific column on another sheet, based on ...
https://support.google.com/docs/thread/74132019/copy-a-cell-value-into-a-specific-column-on-another-sheet-based-on-another-cell-in-its-row?hl=en Sep 30, 2020 ... Again I am not very experienced with Excel and much less experienced with Google Sheets so this may just be too advanced for me to figure out by ...
How Do I Add Up Multiple COUNTA Values? - Google Docs Editors ...
https://support.google.com/docs/thread/99781703/how-do-i-add-up-multiple-counta-values?hl=en Feb 25, 2021 ... COUNTA works well when I have them individually showing separate formulas for separate ... The total amount of cells that can have data in it.) On ...
SPLITTING THE DATA COLLECTED IN FORMS FROM ONE CELL ...
https://support.google.com/docs/thread/66000956/splitting-the-data-collected-in-forms-from-one-cell-to-multiple-rows-in-sheets?hl=en Aug 20, 2020 ... SPLITTING THE DATA COLLECTED IN FORMS FROM ONE CELL TO MULTIPLE ROWS IN SHEETS · First, highlight the cell/row/column you would like to split.
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 ... You show at least two date formats in the data. If there are any others it would be helpful to include samples in your sample document. I ...