Highlight Name List Used More than twice

tlbgto

New Member
Joined
Mar 3, 2011
Messages
17
I have a list of names and I want to highlight the names that are used more than twice. I know conditional formatting will find duplicates, but I need the ones that or used more than twice.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,059
Office Version
  1. 2013
Platform
  1. Windows
tibgto,

Maybe like....
Excel Workbook
A
1Names
2Tom
3Fred
4Tom
5Sid
6Bill
7Tom
8Charlie
9Sid
10Bill
11Sid
12Frank
13Charlie
14Frank
15
Sheet1
#VALUE!


Hope that helps,


 

Watch MrExcel Video

Forum statistics

Threads
1,109,048
Messages
5,526,477
Members
409,702
Latest member
thmoriarty

This Week's Hot Topics

Top