About 1,484,066 results (4,559 milliseconds)
Find value in multiple columns and output matching value in column ...
https://support.google.com/docs/thread/280223766/find-value-in-multiple-columns-and-output-matching-value-in-column-a-in-same-row?hl=en Jun 16, 2024 ... I'd like a formula that looks up a value (S Alabama) in the array (A97:E100), references this sheet, and outputs the value in the same row that is in column B ...
Shift values in multiple rows
https://groups.google.com/g/openrefine/c/qLgNiCM0MDE ... value down by one cell - in multiple rows. For example: Name Age. Mary 20. Sam ... Excel before opening it in OpenRefine. Jonathon Paarlberg's profile ...
Row Number Array from Multiple Conditions - Google Docs Editors ...
https://support.google.com/docs/thread/46236422/row-number-array-from-multiple-conditions?hl=en May 12, 2020 ... I want to expand upon this and only return the row if multiple conditions are true. I want to find all rows that have the same values from row ...
Quickest way to search multiple rows/columns at once for a single ...
https://support.google.com/docs/thread/208630346/quickest-way-to-search-multiple-rows-columns-at-once-for-a-single-true-false-match?hl=en Mar 30, 2023 ... ... multiple cells or multiple IF functions in the same formula. Details ... cells to only include cells that contain the value TRUE. The ...
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.
how to conditional format based on previous row for multiple rows ...
https://support.google.com/docs/thread/191588518/how-to-conditional-format-based-on-previous-row-for-multiple-rows?hl=en Dec 6, 2022 ... This has to continue with rows below, each turning red or green based on the value of the cell one row above. ... check if the row before ...
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've created a simple list using data validation with items in a cell. I've repeated this list over multiple rows in the same column.
How do I enter the same numeric value in an entire column - Google ...
https://support.google.com/docs/thread/149201927/how-do-i-enter-the-same-numeric-value-in-an-entire-column?hl=en Feb 3, 2022 ... So check whether the cell you are copying contains a formula. If you need more help, please share a sample spreadsheet where the issue you ...
Compare 2 sheets for similarities and differences even if on different ...
https://support.google.com/docs/thread/10262301/compare-2-sheets-for-similarities-and-differences-even-if-on-different-rows?hl=en Jul 20, 2019 ... I added two tabs. · Having verified that most of column C matches I go to the other new tab "check". · Check C formula · ={{"Row","No Match C"}; ...
Find and highlight duplicate rows - Google Docs Editors Community
https://support.google.com/docs/thread/199366426/find-and-highlight-duplicate-rows?hl=en Jan 28, 2023 ... The formula in F2 uses the new ByRow() > Lambda() functions to cluster all the data from each row into one value. If you have more columns, just ...
How do I resize a column or row to an exact width/height using the ...
https://support.google.com/docs/thread/11769218/how-do-i-resize-a-column-or-row-to-an-exact-width-height-using-the-sheets-app?hl=en Aug 11, 2019 ... ... row heights or column widths to be equal to an exact value. In fact, I couldn't even find the current values for the heights and widths.
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 vlookup function, by itself, looks up one key value in a list. The arrayformula function in the formula makes it lookup all the cells (D2: ...
How to insert values from one column if there's a match in another ...
https://support.google.com/docs/thread/252642930/how-to-insert-values-from-one-column-if-there-s-a-match-in-another?hl=en Jan 9, 2024 ... I'm working in a sheet with multiple tabs. ... In another tab, I have 300+ rows with percentages in one column and a dollar amount in another.
What is the best way to return multiple values from a single column ...
https://support.google.com/docs/thread/193895683/what-is-the-best-way-to-return-multiple-values-from-a-single-column-lookup?hl=en Dec 21, 2022 ... In other words, I want to calculate the number of total assignments completed within a one week period per subject. Here is a screenshot of the ...
Paste not working correctly on sheets - Google Docs Editors ...
https://support.google.com/docs/thread/33960847/paste-not-working-correctly-on-sheets?hl=en Mar 17, 2020 ... When I copy multiple cells from one spreadsheet (not sheet in the bottom tab) and paste it to another, only the values are pasted. The formulas aren't. The ...
Is there a way to delete multiple blank rows all at once without doing ...
https://support.google.com/docs/thread/199083324/is-there-a-way-to-delete-multiple-blank-rows-all-at-once-without-doing-them-in-groups?hl=en Jan 26, 2023 ... Click "Clear" to clear all values, then click (Blanks) so that it is the only item checked; Click OK; Select all empty rows with your mouse, ...
Pasting over multiple cells not working more than once - Google ...
https://support.google.com/docs/thread/8953776/pasting-over-multiple-cells-not-working-more-than-once?hl=en Jun 29, 2019 ... Today, Google Sheets is only allowing me to paste into one cell at a time unless it's the first paste.
Retrieve value from last row based on multiple criteria - Google ...
https://support.google.com/docs/thread/8972210/retrieve-value-from-last-row-based-on-multiple-criteria?hl=en Jun 29, 2019 ... I have a spreadsheet with two tabs. The first one is used for data input and the second one for extracting data from the first tab and doing some calculations.
Trying to filter out rows based on if values match a different row for a ...
https://support.google.com/docs/thread/170594095/trying-to-filter-out-rows-based-on-if-values-match-a-different-row-for-a-lookup-function?hl=en Jul 10, 2022 ... Automatically filters out columns if one of the jobs for a Cat is selected, and then column Y will search which unassigned Cat is the best for the job.
Unique Combinations from multiple columns - Google Docs Editors ...
https://support.google.com/docs/thread/100385323/unique-combinations-from-multiple-columns?hl=en Mar 2, 2021 ... ... one value for each row and each column. So, if you have A1:A3 & B1 ... So starting near the bottom, we filter D2:D to select all the non-blank ...