counting duplicate values in a coloumn

**macrogeek** · 10-15-2011, 12:52 AM

Sir,
I Want To Count The Duplicate Values IN a Coloumn
Case 1
ALL Entites
Case 2
ONLY Three Entities

**Kenneth Hobson** · 10-15-2011, 01:14 AM

In E2:
=COUNTIF($A$1:$A$30,D2)

**macrogeek** · 10-15-2011, 01:20 AM

Sir,
Using Macros Only Please!

**Kenneth Hobson** · 10-15-2011, 01:45 AM

I included both the formula and the value methods. For the first set, I inserted the formula. For the second set, I set the value.

Please Login or Register  to view this content.

**macrogeek** · 10-15-2011, 02:01 AM

Sir,
Thanks So Much!

Re: counting duplicate values in a coloumn