About 1,878,324 results (3,331 milliseconds)
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 columns in Sheets - Google Docs Editors Community
https://support.google.com/docs/thread/234860840/compare-columns-in-sheets?hl=en Sep 14, 2023 ... Assuming you have the old data in A2:A and the new data in B2:B, enter the following formula in row 2 of an empty column, for example in C2. = ...
Identify duplicates between two columns in Google Sheets - Google ...
https://support.google.com/docs/thread/152011014/identify-duplicates-between-two-columns-in-google-sheets?hl=en Feb 23, 2022 ... ... cells highlight if there is a match in Column B(Entire column) I thought it would be simple but the formula I found is being inconsistent ...
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 ... There are formulas in A1, B1, and D1 that compare the two sheets in the respective columns. It uses filter to make a two column list of values ...
I want to compare two columns and highlight the row if there is a ...
https://support.google.com/docs/thread/2257731/i-want-to-compare-two-columns-and-highlight-the-row-if-there-is-a-difference?hl=en Mar 11, 2019 ... Any help would be appreciated. //Compares two columns and will highlight row if they do not match. function findNonMatchesOKES() {. // gets ...
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 ... The solution would be to have a final Total formula that works this way: return the sum of all values from Required where Req <= Poss, and all ...
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 ... Google Sheet with formula. Conditional Formatting: - Apply to range: B2:D7. Format Cells if. - Is equal to. =$A2. Last edited Apr 29, 2019.
I need a formula to compare information between two tabs and ...
https://support.google.com/docs/thread/351201284/i-need-a-formula-to-compare-information-between-two-tabs-and-highlight-any-differences?hl=en Jun 16, 2025 ... Uploading to Sheets strips this conditional formatting, and using the same or similar formulas is not highlighting changes like it does in Excel ...
Need to take the lowest value in 2 columns - Google Docs Editors ...
https://support.google.com/docs/thread/124781711/need-to-take-the-lowest-value-in-2-columns?hl=en Sep 7, 2021 ... This is what I need to do (example): If cell F3 & G3 is filled, then I want to take the higher value of the two cells compare it to the ...
Formula to MATCH TWO COLUMNS AND LEAVE BLANK ROW IF ...
https://support.google.com/docs/thread/51593792/formula-to-match-two-columns-and-leave-blank-row-if-mismatch?hl=en Jun 5, 2020 ... The ultimate goal is to Align two columns based on the match between them and leave blank row if there is a mismatch or no matching count is available at the ...
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 ... Absolute references (using the $ sign) are for when you want a cell reference (column, row, or both) to remain constant when copying the formula ...
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.
How do I match up values in two columns and sum up the matches ...
https://support.google.com/docs/thread/34775548/how-do-i-match-up-values-in-two-columns-and-sum-up-the-matches?hl=en Mar 21, 2020 ... As you said, all the formulas give the same result. I personally would use. =sumproduct(B1:B,isnumber(match(Sheet2!A1:A ...
Checking against two columns with IF and IFS to apply different ...
https://support.google.com/docs/thread/158089405/checking-against-two-columns-with-if-and-ifs-to-apply-different-sums?hl=en Mar 31, 2022 ... ... two formulas and checking manually to apply it only in the cells that match that first flag. Heck, I don't even know if I did the first part ...
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 ... Some of the cells are empty so I would like to leave it that way in true/false column. Firstly, I've you simple IF function and for empty cell ...
If Two Cells Contain Similar Text, Return a Value - Google Docs ...
https://support.google.com/docs/thread/9769435/if-two-cells-contain-similar-text-return-a-value?hl=en Jul 12, 2019 ... I would use a simple =IF formula to compare information in two cells. If both cells contain the same text, then it would return a certain value.
Compare columns and display missing (using possibly comma ...
https://support.google.com/docs/thread/31792773/compare-columns-and-display-missing-using-possibly-comma-separated-values?hl=en Feb 28, 2020 ... I'm trying to compare two columns and then dynamically display the ... formula into cell H1. =ArrayFormula({"Example Result";iferror ...
Function to display message if the sum of two columns do not match ...
https://support.google.com/docs/thread/51218061/function-to-display-message-if-the-sum-of-two-columns-do-not-match?hl=en Jun 4, 2020 ... I want to use an APPS script function to verify if the sum one column matches the other and display an alert if this condition is not met.
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 ... When I compare values in 2 cells, one containing zero, and the other ... cell (with the exception of array formula result cells.) When ...
Change cell colour if match or no match of two cells - Google Docs ...
https://support.google.com/docs/thread/204813804/change-cell-colour-if-match-or-no-match-of-two-cells?hl=en Mar 5, 2023 ... I have used the following formula to check if cell value match. =IF(A3=B3,"Matching","Not Matching"). but i would like the cell colour to ...