duplicated rows formula

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,570
Hi
I want to highlight duplicated rows. Thanks for your help, I know the formula now but I have had hard time to interpret it.

Conditional Formatting --> Formula

=countif($A$2,$A$200,A2)>1

what exactly this formula is doing? thank you so much
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

sheetspread

Well-known Member
Joined
Sep 19, 2005
Messages
5,117
It's counting how many times each cell appears in the range. Those with a count of 2 or greater will be formatted.
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
if its one particular value you could use conditional format to highlight duplicates. One rows, you might want to concatenate several values together and then CF that
 

Watch MrExcel Video

Forum statistics

Threads
1,114,325
Messages
5,547,263
Members
410,783
Latest member
sonnny
Top