Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to highlight duplicates between two columns?

Google sheets doesn't have a preset conditional formatting for duplicate cells. I need to highlight the cells in column A and B that contains a match/duplicate between the two of them.

like image 651
Kevin Avatar asked Jul 03 '17 07:07

Kevin


People also ask

How do I find the match between two columns in Excel?

Compare Two Columns With a VLOOKUP Function and Find Matching Data. Another way to have Excel find duplicates in two columns is to use a VLOOKUP function. Excel will compare each cell in the second column against the cells in the first column. Use the =VLOOKUP(B2,$A$2:$A$14,1,0) for the column displaying the results.


1 Answers

Please clear formatting from ColumnsA:B, select ColumnA and Format, Conditional formatting..., Format cells if... Custom formula is and:

=countif(B:B,A1)

Then select fill of choice and Done.

Select ColumnB and repeat with:

=countif(A:A,B1)
like image 123
pnuts Avatar answered Dec 01 '22 00:12

pnuts