=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!