Counting......Unique data?

B

bmorris

New Member
Joined
Oct 1, 2010
Messages
48
Hello, I have several thousands of lines of data as seen below. I would like to count each unique person as ONE so I can pivot table the data and average some of the columns. For example I would like to get the average salary AND proper count of painters. I have not been able to get the proper count of 2 for painters because of the several lines of data for each person.
<TABLE style="WIDTH: 342pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=454><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" class=xl65 height=21 width=64>Number</TD><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 91pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" id=td_post_2759174 class=xl66 width=121>Name</TD><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 50pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" class=xl66 width=66>Title</TD><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 50pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" class=xl66 width=66>Age</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #608bb4 1pt solid" class=xl72 width=64>Salary</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 55pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #608bb4 1pt solid" class=xl71 width=73>Cities Worked</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011885</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Aba, Saul A.</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>22,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DC</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011885</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Aba, Saul A.</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>22,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>ATLA</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011885</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Aba, Saul A.</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>22,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>PHNX</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011992</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Smith, Rhonda</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>32</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>30,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LA</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011992</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Smith, Rhonda</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>32</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>30,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011992</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Smith, Rhonda</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>32</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>30,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DLFW</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011687</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Hall, Jen</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>21</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>20,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DC</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011687</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Hall, Jen</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>21</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>20,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>ATLA</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011687</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Hall, Jen</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>21</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>20,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>PHNX</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011700</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Lee, Chris</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>40</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>25,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LA</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011700</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Lee, Chris</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>40</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>25,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011700</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Lee, Chris</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>40</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>25,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DLFW</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DC</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>ATLA</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LA</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011697</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Leeks, Sam</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>32,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011697</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Leeks, Sam</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>32,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DLFW</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011697</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Leeks, Sam</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>32,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD></TR></TBODY></TABLE>
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
bmorris,

Using your sample data, assuming the topleft cell is A1, this formula should work:
Code: 
=SUMPRODUCT((($B$2:$B$20<>"")*($C$2:$C$20="Painter"))/COUNTIFS($B$2:$B$20,$B$2:$B$20,$C$2:$C$20,$C$2:$C$20))



Note that it must be excel 2007 or higher
 
Upvote 0
As you can see in my pivot table....the count of employees is off
<TABLE style="WIDTH: 526pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=700><COLGROUP><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 694" width=19><COL style="WIDTH: 11pt; mso-width-source: userset; mso-width-alt: 548" width=15><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2; WIDTH: 33pt; HEIGHT: 15.75pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" class=xl65 height=21 width=44>Number</TD><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 59pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" id=td_post_2759174 class=xl66 width=78>Name</TD><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 50pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" class=xl66 width=66>Title</TD><TD style="BORDER-BOTTOM: #608bb4 1pt solid; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 20pt; BORDER-TOP: #608bb4 1pt solid; BORDER-RIGHT: #608bb4 1pt solid" class=xl66 width=26>Age</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #608bb4 1pt solid" class=xl72 width=64>Salary</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #608bb4; BACKGROUND-COLOR: #bfd2e2; WIDTH: 55pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #608bb4 1pt solid" class=xl71 width=73>Cities Worked</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 14pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=19></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 11pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=15></TD><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 64pt; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" width=85>Title</TD><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 86pt; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl76 width=115>Average of Salary</TD><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 86pt; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl70 width=115>Count of Number</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011885</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Aba, Saul A.</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>22,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl75>Painter</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76 align=right>23,500.00</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70>6 6</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011885</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Aba, Saul A.</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>22,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>ATLA</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl75>Receptionist</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76 align=right>19,428.57</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70>7 7</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011885</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Aba, Saul A.</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>22,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>PHNX</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl75>Sales</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76 align=right>31,000.00</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70>6 6</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011992</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Smith, Rhonda</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>32</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>30,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LA</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #95b3d7 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl75>Grand Total</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #95b3d7 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl76 align=right>24,368.42</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #95b3d7 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl70>19 19</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011992</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Smith, Rhonda</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>32</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>30,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011992</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Smith, Rhonda</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>32</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>30,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DLFW</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011687</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Hall, Jen</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>21</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>20,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011687</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Hall, Jen</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>21</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>20,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>ATLA</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011687</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Hall, Jen</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>21</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>20,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>PHNX</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011700</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Lee, Chris</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>40</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>25,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LA</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011700</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Lee, Chris</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>40</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>25,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011700</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Lee, Chris</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Painter</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>40</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>25,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DLFW</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>ATLA</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>012555</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Plummer, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Receptionist</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>22</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>19,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LA</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011697</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Leeks, Sam</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>32,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011697</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Leeks, Sam</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>32,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>DLFW</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl67 height=21>011697</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Leeks, Sam</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl68>Sales</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl74>32,000.00</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #cccccc; BORDER-RIGHT: #cccccc 1pt solid" class=xl69>LSVG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70></TD></TR></TBODY></TABLE>
 
Upvote 0
bmorris said:
As you can see in my pivot table....the count of employees is off
<TABLE style="WIDTH: 526pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=700 border=0><COLGROUP><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 694" width=19><COL style="WIDTH: 11pt; mso-width-source: userset; mso-width-alt: 548" width=15><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; WIDTH: 33pt; BORDER-BOTTOM: #608bb4 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #bfd2e2" width=44 height=21>Number</TD><TD class=xl66 id=td_post_2759174 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4; WIDTH: 59pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=78>Name</TD><TD class=xl66 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4; WIDTH: 50pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=66>Title</TD><TD class=xl66 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4; WIDTH: 20pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=26>Age</TD><TD class=xl72 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #608bb4; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #bfd2e2" width=64>Salary</TD><TD class=xl71 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #608bb4; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #bfd2e2" width=73>Cities Worked</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 14pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=19></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 11pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=15></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; WIDTH: 64pt; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" width=85>Title</TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; WIDTH: 86pt; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" width=115>Average of Salary</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; WIDTH: 86pt; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" width=115>Count of Number</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011885</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aba, Saul A.</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">55</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">22,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">DC</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right>23,500.00</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">6 6</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011885</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aba, Saul A.</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">55</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">22,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">ATLA</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right>19,428.57</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">7 7</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011885</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Aba, Saul A.</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">55</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">22,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">PHNX</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right>31,000.00</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">6 6</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011992</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Smith, Rhonda</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">32</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">30,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LA</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #95b3d7 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none">Grand Total</TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #95b3d7 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" align=right>24,368.42</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #95b3d7 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none">19 19</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011992</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Smith, Rhonda</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">32</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">30,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LSVG</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011992</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Smith, Rhonda</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">32</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">30,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">DLFW</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011687</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Hall, Jen</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">21</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">20,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">DC</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011687</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Hall, Jen</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">21</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">20,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">ATLA</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011687</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Hall, Jen</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">21</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">20,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">PHNX</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011700</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lee, Chris</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">40</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">25,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LA</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011700</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lee, Chris</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">40</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">25,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LSVG</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011700</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lee, Chris</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Painter</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">40</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">25,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">DLFW</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>012555</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Plummer, Mary</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">22</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">19,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">DC</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>012555</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Plummer, Mary</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">22</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">19,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">ATLA</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>012555</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Plummer, Mary</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">22</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">19,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LSVG</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>012555</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Plummer, Mary</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Receptionist</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">22</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">19,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LA</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011697</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Leeks, Sam</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">45</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">32,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LSVG</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011697</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Leeks, Sam</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">45</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">32,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">DLFW</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>011697</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Leeks, Sam</TD><TD class=xl68 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sales</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">45</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">32,000.00</TD><TD class=xl69 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">LSVG</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
Click to expand...
For the count of unique painters...

Array entered**:

=SUM(IF(FREQUENCY(IF(C2:C20="Painter",MATCH(B2:B20,B2:B20,0)),ROW(B2:B20)-ROW(B2)+1),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.
 
Upvote 0
Just for clarification.....because I am not an excel expert.....:(.....This formula should be insert in its own column? and for any of the titles I want to count other than painter.....I will need to alter the formula?
 
Upvote 0
bmorris said:
Just for clarification.....because I am not an excel expert.....:(.....This formula should be insert in its own column? and for any of the titles I want to count other than painter.....I will need to alter the formula?
Click to expand...

Try the following as another column in your raw data. Then when you pivot it use SUM not count:

Excel Workbook
ABCDEFG
1NumberNameTitleAgeSalaryCities Worked# of Employees
211885Aba, Saul A.Painter5522,000.00DC0.333333333
311885Aba, Saul A.Painter5522,000.00ATLA0.333333333
411885Aba, Saul A.Painter5522,000.00PHNX0.333333333
511992Smith, RhondaSales3230,000.00LA0.333333333
611992Smith, RhondaSales3230,000.00LSVG0.333333333
711992Smith, RhondaSales3230,000.00DLFW0.333333333
811687Hall, JenReceptionist2120,000.00DC0.333333333
911687Hall, JenReceptionist2120,000.00ATLA0.333333333
1011687Hall, JenReceptionist2120,000.00PHNX0.333333333
1111700Lee, ChrisPainter4025,000.00LA0.333333333
1211700Lee, ChrisPainter4025,000.00LSVG0.333333333
1311700Lee, ChrisPainter4025,000.00DLFW0.333333333
1412555Plummer, MaryReceptionist2219,000.00DC0.25
1512555Plummer, MaryReceptionist2219,000.00ATLA0.25
1612555Plummer, MaryReceptionist2219,000.00LSVG0.25
1712555Plummer, MaryReceptionist2219,000.00LA0.25
1811697Leeks, SamSales4532,000.00LSVG0.333333333
1911697Leeks, SamSales4532,000.00DLFW0.333333333
2011697Leeks, SamSales4532,000.00LSVG0.333333333
Sheet1
 
Upvote 0
bmorris said:
Just for clarification.....because I am not an excel expert.....:(.....This formula should be insert in its own column? and for any of the titles I want to count other than painter.....I will need to alter the formula?
Click to expand...
That formula is for a single cell and returns the count of unique names that correspond to the title that you can define.

In the formula I have hard coded the title "painter" but you can use a range of cells to hold the different titles and then refer to those cells:

Book1
IJ
2Painter2
3Receptionist2
4Sales2
Sheet1

Array entered** in J2 and copied down:

=SUM(IF(FREQUENCY(IF(C$2:C$20=I2,MATCH(B$2:B$20,B$2:B$20,0)),ROW(B$2:B$20)-ROW(B$2)+1),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
 
Upvote 0
try this one, a is the number of unique data

Range("A1:A1000").AdvancedFilter Action:=xlFilterInPlace, Unique:=True

'copy the result to a new spreadsheet
Range("A1:B1000").Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("sheet2").Select
Range("a1").Select
ActiveSheet.Paste

' count rows
a= ActiveSheet.UsedRange.rows.count
 
Upvote 0
T. Valko said:
That formula is for a single cell and returns the count of unique names that correspond to the title that you can define.

In the formula I have hard coded the title "painter" but you can use a range of cells to hold the different titles and then refer to those cells:

Book1
*IJ
2Painter2
3Receptionist2
4Sales2
Sheet1

Array entered** in J2 and copied down:

=SUM(IF(FREQUENCY(IF(C$2:C$20=I2,MATCH(B$2:B$20,B$2:B$20,0)),ROW(B$2:B$20)-ROW(B$2)+1),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
Click to expand...

pls sir can you explain this formula in layman. ? i want learning this formula pls help.
 
Upvote 0
lundbhaiz said:
pls sir can you explain this formula in layman. ? i want learning this formula pls help.
Click to expand...
We want to count the unique names for the painters. Let's use this smaller data sample to see how this works:

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Verdana,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=0><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 72px"><COL style="WIDTH: 50px"><COL style="WIDTH: 50px"><COL style="WIDTH: 50px"><COL style="WIDTH: 50px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid">Painter</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Joe</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Painter</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">2</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Carpenter</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Tom</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Welder</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Bill</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Painter</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Frank</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Painter</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">Joe</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; COLOR: #ffffff; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid">_</TD></TR></TBODY></TABLE>


This array formula** entered in E1:

=SUM(IF(FREQUENCY(IF(A$1:A$5=D1,MATCH(B$1:B$5,B$1:B$5,0)),ROW(B$1:B$5)-ROW(B$1)+1),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.

We want to count the unique names for the painters. Let's use this smaller data sample to see how this works:

=SUM(IF(FREQUENCY(IF(A$1:A$5=D1,MATCH(B$1:B$5,B$1:B$5,0)),ROW(B$1:B$5)-ROW(B$1)+1),1))

Result = 2

Everything is dependent upon the entries in column A being "painter". So we use the IF function to test the entries in column A to see if they contain "painter": IF(A$1:A$5=D1...

With this test we get an array of TRUE or FALSE.

A1 = D1 = T
A2 = D1 = F
A3 = D1 = F
A4 = D1 = T
A5 = D1 = T

Where this condition is TRUE we use MATCH to generate an array of values that we will then use to get the count of the frequencies from.
MATCH returns the relative position of the lookup value within the lookup array. MATCH will find only the first instance of the lookup value when there are duplicate lookup values. The lookup values are the painter names and the lookup array is also the painter names.

MATCH("Joe",B1:B5,0) = 1
MATCH("Tom",B1:B5,0) = 2
MATCH("Bill",B1:B5,0) = 3
MATCH("Frank",B1:B5,0) = 4
MATCH("Joe",B1:B5,0) = 1

Notice how there are 2 instances of 1. This is because of the duplicate lookup values "Joe" and that MATCH will only find the first instance of a lookup value.

Where the IF function test is TRUE: IF(A$1:A$5=D1, the result of the IF function will be the corresponding result of the MATCH function. Where the IF function test is FALSE the result will also be FALSE:

T..1 = 1
F..2 = F
F..3 = F
T..4 = 4
T..1 = 1

This array is passed to the FREQUENCY function and is the data array argument of the FREQUENCY function. The FREQUENCY function does a series of "count if's". It counts how many items in the data array meet certain conditions. In this case, those conditions are a series of numbers called the bins array. Since MATCH returns a series of specific numbers we want to count just how many of each of those specific numbers there are. Since the range we want to count is B1:B5 (5 rows), that means the result of MATCH could be a number from 1 to 5. So, we want to count how many 1s, 2s, 3s, 4s and 5s are in the data array. So, we need to tell the FREQUENCY function we want to count the numbers 1,2,3,4,5. We do this using this expression:

ROW(B$1:B$5)-ROW(B$1)+1

That expression will return the array 1;2;3;4;5

ROW(B1)-ROW(B1)+1 = 1
ROW(B2)-ROW(B1)+1 = 2
ROW(B3)-ROW(B1)+1 = 3
ROW(B4)-ROW(B1)+1 = 4
ROW(B5)-ROW(B1)+1 = 5

At this point this is what the FREQUENCY function looks like:

FREQUENCY{1;F;F;4;1},{1,2,3,4,5}

As I mentioned above, FREQUENCY returns a series of "count if's" on the data array based on the values of the bins array. These are those "count if's" :

count if data array is <=1
count if data array is >1 and <=2
count if data array is >2 and <=3
count if data array is >3 and <=4
count if data array is >4 and <=5
count if data array is >5

And these are the results of those "count if"s":

{1;F;F;4;1} <=1 = 2
{1;F;F;4;1} >1 and <=2 = 0
{1;F;F;4;1} >2 and <=3 = 0
{1;F;F;4;1} >3 and <=4 = 1
{1;F;F;4;1} >4 and <=5 = 0
{1;F;F;4;1} >5 = 0

The logical FALSE is ignored.

Now we're getting pretty close to the end result!

The results of the FREQUENCY function are then passed to the outer IF function. At this point the formula looks like this:

=SUM(IF({2;0;0;1;0;0},1))

We take advantage of a little "trick" about the IF function. Typically, an IF function is made up of 3 arguments:

logical test
value if TRUE
value if FALSE

The logical test is usually a test for some condition. For example, the inner IF is using the logical test of: A$1:A$5=D1. It's testing each cell in the range A1:A5 to see if it equals what's in cell D1. The result of this test is either an array of TRUE or FALSE. If the result is TRUE then the IF function returns the value if TRUE argument. If the result is FALSE then the IF function returns the value if FALSE argument.

In Excel, numbers can also be used to represent TRUE and FALSE. Typically, 1 = TRUE and 0 = FALSE. However, in Excel *any number other than 0* will be evaluated as TRUE. So, with our formula now looking like this:

=SUM(IF({2;0;0;1;0;0},1))

We get this:

IF 2 = T
IF 0 = F
IF 0 = F
IF 1 = T
IF 0 = F
IF 0 = F

Where the logical test is TRUE, return the value if TRUE argument of 1. Where the logical test is FALSE, return the value if FALSE argument of _____. Ah, now what? We haven't defined a value if FALSE argument. Since we haven't done that the IF function will return the default value of FALSE.

IF 2 = T = 1
IF 0 = F = F
IF 0 = F = F
IF 1 = T = 1
IF 0 = F = F
IF 0 = F = F

These results are then passed to the SUM function and summed to get our FINAL result:

=SUM({1;F;F;1;F;F})

=2

So:

Count the unique names of the painters:

=SUM(IF(FREQUENCY(IF(A$1:A$5=D1,MATCH(B$1:B$5,B$1:B$5,0)),ROW(B$1:B$5)-ROW(B$1)+1),1))

=2
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
842
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
E
  • Question
VBA for Web Scraping help
Replies
0
Views
599
epactheactor
E
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
354
esben
E
V
  • Question
Issue with scraping with VBA
Replies
1
Views
519
John_w
J

Forum statistics

Threads
1,215,136
Messages
6,123,246
Members
449,093
Latest member
Vincent Khandagale

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top