Microsoft Office Forums - View Single Post - Count Duplicate Values without a specific Unique Value

Thread: Count Duplicate Values without a specific Unique Value

View Single Post

Old

02-01-2017, 06:22 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

The easiest method, place in C2 and copy down...

=COUNTIF($A$2:$A$19,A2)

...now filter column C by anything greater than 1

Copy and paste

Reply With Quote