About 1,978,440 results (2,857 milliseconds)
Compare cell on sheet2 to cells in column on sheet1 and return ...
https://support.google.com/docs/thread/5083754/compare-cell-on-sheet2-to-cells-in-column-on-sheet1-and-return-value-of-adjacent-cell?hl=en Apr 28, 2019 ... ... column and output the value of the cell left of the matching value cell. ... In the example spreadsheet I made this adds up to wanting cell ...
Comparing blank cell with a cell containing '0' is equating to TRUE ...
https://support.google.com/docs/thread/75135122/comparing-blank-cell-with-a-cell-containing-0-is-equating-to-true-all-of-a-sudden?hl=en Oct 6, 2020 ... Bunch of my spreadsheet formulas are now messed up. Is this a recent logic change?!! It used to equate to FALSE. Details. Sheets ...
Time Comparison Formula Issue - Google Docs Editors Community
https://support.google.com/docs/thread/237932873/time-comparison-formula-issue?hl=en Oct 5, 2023 ... I then also have a comparison issue in a formula that is comparing this value to another TIME cell. ... spreadsheet where the issue can be ...
SUMIF - compare 2 whole columns for each row (cell range in ...
https://support.google.com/docs/thread/73714767/sumif-compare-2-whole-columns-for-each-row-cell-range-in-criteria?hl=en Sep 28, 2020 ... If you need more help, please share a sample spreadsheet rather than a screenshot. Cheers --Hyde. Last edited Sep 28, 2020. Original Poster ...
Compare two columns - highlight which cell is greater - Google Docs ...
https://support.google.com/docs/thread/259649122/compare-two-columns-highlight-which-cell-is-greater?hl=en Feb 19, 2024 ... I am trying to compare two columns, column 1 is data from 2023 and column 2 is data from 2024. Each day is listed for the years and I'd like to compare the ...
IF formula returns FALSE while comparing to equal numbers ...
https://support.google.com/docs/thread/193901389/if-formula-returns-false-while-comparing-to-equal-numbers?hl=en Dec 22, 2022 ... I have an IF formula, comparing two cells with the same number! and it returns FALSE. Note: these cells are being calculated from other tabs, among which some ...
Compare 2 or more columns and return a color value - Google Docs ...
https://support.google.com/docs/thread/5126809/compare-2-or-more-columns-and-return-a-color-value?hl=en Apr 29, 2019 ... I'm trying to compare cells. I think I can do this with conditional formatting but I cannot figure it out. Not much of a spreadsheet guy. I want ...
Compare columns in Sheets - Google Docs Editors Community
https://support.google.com/docs/thread/234860840/compare-columns-in-sheets?hl=en Sep 14, 2023 ... The entries in both columns are numerical values. So I need to check if any of the cell values in column B are found anywhere in column A, not ...
Conditional formatting to compare cell text with text in other multiple ...
https://support.google.com/docs/thread/12609403/conditional-formatting-to-compare-cell-text-with-text-in-other-multiple-cells?hl=en Aug 22, 2019 ... Using a formula in conditional formatting to compare a cell's text with text within a range of other multiple cells.
How to QUERY/INDEX+MATCH multiple rows of text from a merged ...
https://support.google.com/docs/thread/11089976/how-to-query-index-match-multiple-rows-of-text-from-a-merged-cell?hl=en Aug 1, 2019 ... I've been trying multiple methods of using VLOOKUP, INDEX+MATCH, and QUERY to output 2-3 rows of information based on a drop-down merged cell.
Using conditional formatting, compare value to previous non blank ...
https://support.google.com/docs/thread/284071109/using-conditional-formatting-compare-value-to-previous-non-blank-cell-in-the-same-row?hl=en Jul 7, 2024 ... ... compare the values to the previous cell value, skipping blank cells? ... If you need more help, please share a sample spreadsheet rather than a ...
Conditional Formatting if cell is greater/less than cell above - Google ...
https://support.google.com/docs/thread/40734495/conditional-formatting-if-cell-is-greater-less-than-cell-above?hl=en Apr 17, 2020 ... ... cell it should be comparing. I've read about 20 threads on how to do this and none of them seem to work. All CF has been removed. See column G.
Apps Script for Excel and Compare a date to today
https://groups.google.com/g/google-apps-script-community/c/zGdlzlsFU3s I am trying to compare a date from a cell in Sheets to today, and run a script if they match. Here's what I have:
How do I apply conditional formatting to a cell in 1 column if it is not ...
https://support.google.com/docs/thread/145584570/how-do-i-apply-conditional-formatting-to-a-cell-in-1-column-if-it-is-not-equal-to-value-in-other-col?hl=en Jan 13, 2022 ... Thank you for sharing a sample spreadsheet. It helps understand what you are actually asking. What we are talking about is not a match across ...
How to Check and Compare Sheet names to an array- or list ...
https://support.google.com/docs/thread/97739530/how-to-check-and-compare-sheet-names-to-an-array-or-list?hl=en Feb 11, 2021 ... This formula will refresh automatically every time any cell in the spreadsheet is hand edited. uses indirect functions to dynamically change ...
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 ... See the new Solution sheet in your sample spreadsheet for an illustration. The formula is in cell B1 . For that to work, you will have to ...
Comparison of two dates leaving blank cells - Google Docs Editors ...
https://support.google.com/docs/thread/104753811/comparison-of-two-dates-leaving-blank-cells?hl=en Apr 2, 2021 ... I would like to compare two dates in different columns and count if one date is more recent then other.
Conditional Formatting to Compare Two Cells in Two Sheets ...
https://support.google.com/docs/thread/23498192/conditional-formatting-to-compare-two-cells-in-two-sheets?hl=en Dec 21, 2019 ... Please note that I updated the formula. Check my previous commend. I also updated it in your spreadsheet. Ben Liebrand.
Changing Cell Color By Comparison to Values From Table Based ...
https://support.google.com/docs/thread/109509964/changing-cell-color-by-comparison-to-values-from-table-based-on-selection-from-drop-down-menu?hl=en May 11, 2021 ... That is roughly what it would look like in Python, but I'm not very familiar with Excel ... cells in Column C based on how they compare to Columns ...
MATCH function - Google Docs Editors Help
https://support.google.com/docs/answer/3093378?hl=en MATCH function · VLOOKUP : Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.