Comments on: A Simple Google Sheets Compare Two Columns Guide for 2024

By: Talha Shaikh

Talha Shaikh — Mon, 02 Oct 2023 18:03:34 +0000

Hello! wonderful guide, Quick Question what if i have multiple entries in the a single cell ( e.g Location a customer has used for our stores) and want to compare the updated list for same data, But wanted to compare to see if any new store has shwon up in the list in the cell

Columns A Column B
Houston, Sugarland, Katy Houston, Katy, Sugarland, the Woodlands

So want to compare Cell B2 with A2 and In Cell C spit out the Woodlands as a new location added

Is that possible?

Thank you

By: Karen Burton

Karen Burton — Mon, 28 Aug 2023 07:43:10 +0000

Fantastic!

By: Christopher Daniel

Christopher Daniel — Wed, 14 Dec 2022 03:41:32 +0000

In reply to Will Trotte.

Try using this guide instead https://spreadsheetpoint.com/highlight-duplicates-google-sheets/

By: Nora McDougall-Collins

Nora McDougall-Collins — Mon, 28 Nov 2022 16:21:12 +0000

This is very helpful and comprehensive.

By: Crystal

Crystal — Sun, 04 Sep 2022 12:56:12 +0000

Hi, what if I want to use Google Sheets Conditional Formatting to compare columns in two different sheet, what will the =countif formula be? Thank you.

By: Jay

Jay — Thu, 14 Apr 2022 17:25:33 +0000

Thanks so much for this!

By: hanuman

hanuman — Mon, 21 Mar 2022 13:58:03 +0000

Thank you so much.
Very easy to understand and helped me a lot.

By: Kat. T

Kat. T — Sat, 12 Feb 2022 17:36:35 +0000

Hi! I’m trying to create a color coded google sheet in order to track student grades.
If I had to describe the google sheet basic set up, students names are in the first column, next column has score (0-50), and then the second column has the following week’s scores, again (0-50).

I used your formula for comparing 2 cells on the same row, but different columns, and modified it to color a cell green if the value in it is greater than the value in the cell before it on the same row (so from =$A2=$B2 to =$A2>$B2). I then added 2 other conditional format formulas, to show a different color that cell is lower than the adjacent cell before it (=$A2$B2 on row 5 (=$A2>$B2 instead of =$A5>$B5).

Is there any extra step, or change I can make to the formula so that it populates correctly for each row, without me having to write 3 different formulas for every single cell?

Thanks for your help!

By: Michael

Michael — Thu, 10 Jun 2021 11:14:08 +0000

This shows how to format the cells but how do we get the number of rows matching and how do we then determine how closely matched the two data sets are?

By: Will Trotte

Will Trotte — Wed, 26 May 2021 20:25:59 +0000

Looking for a formula that would highlight duplicates. Specifically, I would need to compare the cells of an entire column (N) against all cells in the previous columns (A-M) and only highlight the duplicates from column N and the sister cells (if possible). I do not want the formula to compare columns A-M against each other for duplicates. I was using this formula, but found that each cell is being compared to all other cells and highlighting all dupes. Taking too much time to process. Any help would be awesome! Thanks!

=COUNTIF($A$2:N6000,Indirect(Address(Row(),Column(),)))>1