Counting Locations....easy?

[bmorris]

I have a list of data as shown below......and feel like the simplest thing such as counting how many locations we have should be easy! But I can not think of a formula that will easily give me the number of locations from this list.......any ideas?
<TABLE style="WIDTH: 149pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=199 border=0><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 108pt; mso-width-source: userset; mso-width-alt: 5266" width=144><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; WIDTH: 41pt; BORDER-BOTTOM: #608bb4 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #bfd2e2" width=55 height=18>Loc#</TD><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4; WIDTH: 108pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=144>Loc</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0335</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Raleigh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0335</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Raleigh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0335</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Raleigh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR></TBODY></TABLE>

 

[JackDanIce]

Do you mean COUNTIF:
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 8pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 116px"><COL style="WIDTH: 56px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-WEIGHT: bold">Loc#</TD><TD style="FONT-WEIGHT: bold">Loc</TD><TD style="FONT-WEIGHT: bold">Count</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">335</TD><TD>AROC Raleigh</TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right">335</TD><TD>AROC Raleigh</TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: right">335</TD><TD>AROC Raleigh</TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD><TD style="TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: right">5180</TD><TD>Ashburn Farm</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: right">5180</TD><TD>Ashburn Farm</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: right">5180</TD><TD>Ashburn Farm</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: right">5180</TD><TD>Ashburn Farm</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: right">5110</TD><TD>Aventura</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: right">5110</TD><TD>Aventura</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: right">5110</TD><TD>Aventura</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: right">5110</TD><TD>Aventura</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: right">5110</TD><TD>Aventura</TD><TD style="TEXT-ALIGN: right">5</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C2</TD><TD>=COUNTIF($B$2:$B$51,B2)</TD></TR><TR><TD>C3</TD><TD>=COUNTIF($B$2:$B$51,B3)</TD></TR><TR><TD>C4</TD><TD>=COUNTIF($B$2:$B$51,B4)</TD></TR><TR><TD>C5</TD><TD>=COUNTIF($B$2:$B$51,B5)</TD></TR><TR><TD>C6</TD><TD>=COUNTIF($B$2:$B$51,B6)</TD></TR><TR><TD>C7</TD><TD>=COUNTIF($B$2:$B$51,B7)</TD></TR><TR><TD>C8</TD><TD>=COUNTIF($B$2:$B$51,B8)</TD></TR><TR><TD>C9</TD><TD>=COUNTIF($B$2:$B$51,B9)</TD></TR><TR><TD>C10</TD><TD>=COUNTIF($B$2:$B$51,B10)</TD></TR><TR><TD>C11</TD><TD>=COUNTIF($B$2:$B$51,B11)</TD></TR><TR><TD>C12</TD><TD>=COUNTIF($B$2:$B$51,B12)</TD></TR><TR><TD>C13</TD><TD>=COUNTIF($B$2:$B$51,B13)</TD></TR><TR><TD>C14</TD><TD>=COUNTIF($B$2:$B$51,B14)</TD></TR><TR><TD>C15</TD><TD>=COUNTIF($B$2:$B$51,B15)</TD></TR><TR><TD>C16</TD><TD>=COUNTIF($B$2:$B$51,B16)</TD></TR><TR><TD>C17</TD><TD>=COUNTIF($B$2:$B$51,B17)</TD></TR><TR><TD>C18</TD><TD>=COUNTIF($B$2:$B$51,B18)</TD></TR><TR><TD>C19</TD><TD>=COUNTIF($B$2:$B$51,B19)</TD></TR><TR><TD>C20</TD><TD>=COUNTIF($B$2:$B$51,B20)</TD></TR><TR><TD>C21</TD><TD>=COUNTIF($B$2:$B$51,B21)</TD></TR><TR><TD>C22</TD><TD>=COUNTIF($B$2:$B$51,B22)</TD></TR><TR><TD>C23</TD><TD>=COUNTIF($B$2:$B$51,B23)</TD></TR><TR><TD>C24</TD><TD>=COUNTIF($B$2:$B$51,B24)</TD></TR><TR><TD>C25</TD><TD>=COUNTIF($B$2:$B$51,B25)</TD></TR><TR><TD>C26</TD><TD>=COUNTIF($B$2:$B$51,B26)</TD></TR><TR><TD>C27</TD><TD>=COUNTIF($B$2:$B$51,B27)</TD></TR><TR><TD>C28</TD><TD>=COUNTIF($B$2:$B$51,B28)</TD></TR><TR><TD>C29</TD><TD>=COUNTIF($B$2:$B$51,B29)</TD></TR><TR><TD>C30</TD><TD>=COUNTIF($B$2:$B$51,B30)</TD></TR><TR><TD>C31</TD><TD>=COUNTIF($B$2:$B$51,B31)</TD></TR><TR><TD>C32</TD><TD>=COUNTIF($B$2:$B$51,B32)</TD></TR><TR><TD>C33</TD><TD>=COUNTIF($B$2:$B$51,B33)</TD></TR><TR><TD>C34</TD><TD>=COUNTIF($B$2:$B$51,B34)</TD></TR><TR><TD>C35</TD><TD>=COUNTIF($B$2:$B$51,B35)</TD></TR><TR><TD>C36</TD><TD>=COUNTIF($B$2:$B$51,B36)</TD></TR><TR><TD>C37</TD><TD>=COUNTIF($B$2:$B$51,B37)</TD></TR><TR><TD>C38</TD><TD>=COUNTIF($B$2:$B$51,B38)</TD></TR><TR><TD>C39</TD><TD>=COUNTIF($B$2:$B$51,B39)</TD></TR><TR><TD>C40</TD><TD>=COUNTIF($B$2:$B$51,B40)</TD></TR><TR><TD>C41</TD><TD>=COUNTIF($B$2:$B$51,B41)</TD></TR><TR><TD>C42</TD><TD>=COUNTIF($B$2:$B$51,B42)</TD></TR><TR><TD>C43</TD><TD>=COUNTIF($B$2:$B$51,B43)</TD></TR><TR><TD>C44</TD><TD>=COUNTIF($B$2:$B$51,B44)</TD></TR><TR><TD>C45</TD><TD>=COUNTIF($B$2:$B$51,B45)</TD></TR><TR><TD>C46</TD><TD>=COUNTIF($B$2:$B$51,B46)</TD></TR><TR><TD>C47</TD><TD>=COUNTIF($B$2:$B$51,B47)</TD></TR><TR><TD>C48</TD><TD>=COUNTIF($B$2:$B$51,B48)</TD></TR><TR><TD>C49</TD><TD>=COUNTIF($B$2:$B$51,B49)</TD></TR><TR><TD>C50</TD><TD>=COUNTIF($B$2:$B$51,B50)</TD></TR><TR><TD>C51</TD><TD>=COUNTIF($B$2:$B$51,B51)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Or you can perform an Advanced Filter on your data set to show the unique values only:

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 8pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 116px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-WEIGHT: bold">Loc#</TD><TD style="FONT-WEIGHT: bold">Loc</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">2800</TD><TD>Addison</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">50201</TD><TD>Amber Oaks</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">340</TD><TD>AROC Charlotte</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">335</TD><TD>AROC Raleigh</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">325</TD><TD>AROC Washington DC</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">5180</TD><TD>Ashburn Farm</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">5110</TD><TD>Aventura</TD></TR></TBODY></TABLE>

 

[bmorris]

Thank you so much for your quick response! What I meant is.....you see each location has several lines.......I only want each location change to be counted as 1 location. We have a rather large database and I am trying to determine how many locations we currently have in use. Does that make better sense?

 

[T. Valko]

I have a list of data as shown below......and feel like the simplest thing such as counting how many locations we have should be easy! But I can not think of a formula that will easily give me the number of locations from this list.......any ideas?
<TABLE style="WIDTH: 149pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=199 border=0><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 108pt; mso-width-source: userset; mso-width-alt: 5266" width=144><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; WIDTH: 41pt; BORDER-BOTTOM: #608bb4 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #bfd2e2" width=55 height=18>Loc#</TD><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4; WIDTH: 108pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=144>Loc</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>2800</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Addison</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>50201</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Amber Oaks</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0340</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Charlotte</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0335</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Raleigh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0335</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Raleigh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0335</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Raleigh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>0325</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">AROC Washington DC</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5180</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Ashburn Farm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>5110</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aventura</TD></TR></TBODY></TABLE>

Are you expecting a result of 7?

This formula will work as long as there are no empty cells within the data range of column B.

=SUMPRODUCT(1/COUNTIF(B2:B51,B2:B51))

That formula will be slow to calculate if you have 1000's of rows of data.

This array formula** is better if that's the case.

=SUM(IF(FREQUENCY(MATCH(B2:B51,B2:B51,0),ROW(B2:B51)-ROW(B2)),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Also assumes no empty cells within the data range of column B.

 

[jberwald]

On the other hand, if you are just looking to see how many different locations are mentioned - on the info you offered the answer would be 7 different locations then try this.

=SUMPRODUCT((B1:B100<>"")/COUNTIF(B1:B100,B1:B100&""))

 

[bmorris]

That last formula you suggested worked GREAT!!!!!!!! Thank you so much!!!!!!!!!!!