Counting Multiple Addresses

[Kate A.]

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]

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)

 

[Bob Phillips]

=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.]

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