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!