ExcelBanter - Counting Multiple Addresses

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting Multiple Addresses (https://www.excelbanter.com/excel-worksheet-functions/200757-counting-multiple-addresses.html)

Counting Multiple Addresses

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!

Counting Multiple Addresses

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)

Counting Multiple Addresses

=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 wrote in message
...
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!

Counting Multiple Addresses

"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