Hi Everyone,

I have a file that has about 6727 rows. I need to count up how many times
the addresses in a particular column (A) is repeated. I've already created a
new "filtered addresses" column (B) but I'm not sure which function would
allow me to count how many times the addresses repeat in the original column.
What's the easiest way for this to work???

Example: (sorry About the formatting)

Column A:
ADDRESS
346 SAINT PAUL ST
61 PARK ST
50 PLEASANT ST
3 ENGLEWOOD AVE
615 HEATH ST
615 HEATH ST
99 PARK ST
92 LANCASTER TER
70 WINCHESTER ST
100 CENTRE ST
100 CENTRE ST
ELIOT & BOYLSTON
GODDARD AVE & COTTAGE ST
GODDARD AVE & COTTAGE ST
GODDARD AVE & COTTAGE ST
GODDARD AVE & COTTAGE ST
100 CENTRE ST
100 CENTRE ST

Column B:

FILTERED
346 SAINT PAUL ST
61 PARK ST
50 PLEASANT ST
3 ENGLEWOOD AVE
615 HEATH ST
99 PARK ST
92 LANCASTER TER
70 WINCHESTER ST
100 CENTRE ST
ELIOT & BOYLSTON
GODDARD AVE & COTTAGE ST

Thanks in advance!

Kate A. wrote:
> Hi Everyone,
>
> I have a file that has about 6727 rows. I need to count up how many times
> the addresses in a particular column (A) is repeated. I've already created a
> new "filtered addresses" column (B) but I'm not sure which function would
> allow me to count how many times the addresses repeat in the original column.
> What's the easiest way for this to work???
>
> Example: (sorry About the formatting)
>
> Column A:
> ADDRESS
> 346 SAINT PAUL ST
> 61 PARK ST
> 50 PLEASANT ST
> 3 ENGLEWOOD AVE
> 615 HEATH ST
> 615 HEATH ST
> 99 PARK ST
> 92 LANCASTER TER
> 70 WINCHESTER ST
> 100 CENTRE ST
> 100 CENTRE ST
> ELIOT & BOYLSTON
> GODDARD AVE & COTTAGE ST
> GODDARD AVE & COTTAGE ST
> GODDARD AVE & COTTAGE ST
> GODDARD AVE & COTTAGE ST
> 100 CENTRE ST
> 100 CENTRE ST
>
> Column B:
>
> FILTERED
> 346 SAINT PAUL ST
> 61 PARK ST
> 50 PLEASANT ST
> 3 ENGLEWOOD AVE
> 615 HEATH ST
> 99 PARK ST
> 92 LANCASTER TER
> 70 WINCHESTER ST
> 100 CENTRE ST
> ELIOT & BOYLSTON
> GODDARD AVE & COTTAGE ST
>
> Thanks in advance!
>


With your Addresses in A2:A19 and your Filtered list in B2:B12, put the
following in C2 and copy down:

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

=COUNTIF(A:A,B2)

and copy down.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kate A." <Kate A.@discussions.microsoft.com> wrote in message
news:FC0EEBAC-E70B-476D-8111-(E-Mail Removed)...
> Hi Everyone,
>
> I have a file that has about 6727 rows. I need to count up how many times
> the addresses in a particular column (A) is repeated. I've already
> created a
> new "filtered addresses" column (B) but I'm not sure which function would
> allow me to count how many times the addresses repeat in the original
> column.
> What's the easiest way for this to work???
>
> Example: (sorry About the formatting)
>
> Column A:
> ADDRESS
> 346 SAINT PAUL ST
> 61 PARK ST
> 50 PLEASANT ST
> 3 ENGLEWOOD AVE
> 615 HEATH ST
> 615 HEATH ST
> 99 PARK ST
> 92 LANCASTER TER
> 70 WINCHESTER ST
> 100 CENTRE ST
> 100 CENTRE ST
> ELIOT & BOYLSTON
> GODDARD AVE & COTTAGE ST
> GODDARD AVE & COTTAGE ST
> GODDARD AVE & COTTAGE ST
> GODDARD AVE & COTTAGE ST
> 100 CENTRE ST
> 100 CENTRE ST
>
> Column B:
>
> FILTERED
> 346 SAINT PAUL ST
> 61 PARK ST
> 50 PLEASANT ST
> 3 ENGLEWOOD AVE
> 615 HEATH ST
> 99 PARK ST
> 92 LANCASTER TER
> 70 WINCHESTER ST
> 100 CENTRE ST
> ELIOT & BOYLSTON
> GODDARD AVE & COTTAGE ST
>
> Thanks in advance!
>

"Glenn" wrote:
>
> With your Addresses in A2:A19 and your Filtered list in B2:B12, put the
> following in C2 and copy down:
>
> =COUNTIF($A$2:$A$19,B2)

Thanks for your responce Glen! Worked perfectly!

I was making this WAY more complicated than it needed to be! : P