duplicated rows formula

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,568
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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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,113,824
Messages
5,544,541
Members
410,619
Latest member
gregor222
Top