Help....Excel Formula

B

bmorris

New Member
Joined
Oct 1, 2010
Messages
48
I posted this yesterday but I wasn't really clear on what I expected. Please let me know asap if this is possible! Any suggestions would be greatly appreciated! In the example below, I would expect to get a count of unique employees within each month. So in month 1 the count would be 3 employees.....2=2....and 3=4.
<TABLE style="WIDTH: 198pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=263 border=0><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: #608bb4 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #bfd2e2" width=94 height=21>Employee Number</TD><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT-COLOR: #608bb4; WIDTH: 79pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=105>Employee Name</TD><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT-COLOR: #608bb4; WIDTH: 48pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=64>Month</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001014</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mike</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001014</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mike</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001016</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sam</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001021</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mary</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001021</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mary</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001023</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lance</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001023</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lance</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001030</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Kim</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001030</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Kim</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001030</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Kim</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001041</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Teresa</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001041</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Teresa</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001046</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Bob</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001046</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Bob</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001053</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Susie</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>012135</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lori</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR></TBODY></TABLE><!-- / message -->
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Thank you so much for your quick response.....and the link! There is other data in this spreadsheet......so although it appears to have duplicate names it really isn't. I suppose I will sort it down by month then employee and do a subtotal to get around the duplicates.
 
Upvote 0
bmorris said:
I posted this yesterday but I wasn't really clear on what I expected. Please let me know asap if this is possible! Any suggestions would be greatly appreciated! In the example below, I would expect to get a count of unique employees within each month. So in month 1 the count would be 3 employees.....2=2....and 3=4.
<TABLE style="WIDTH: 198pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=263 border=0><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT: #608bb4 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: #608bb4 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #bfd2e2" width=94 height=21>Employee Number</TD><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT-COLOR: #608bb4; WIDTH: 79pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=105>Employee Name</TD><TD class=xl63 style="BORDER-RIGHT: #608bb4 1pt solid; BORDER-TOP: #608bb4 1pt solid; BORDER-LEFT-COLOR: #608bb4; WIDTH: 48pt; BORDER-BOTTOM: #608bb4 1pt solid; BACKGROUND-COLOR: #bfd2e2" width=64>Month</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001014</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mike</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-TOP: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001014</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mike</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001016</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Sam</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001021</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mary</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001021</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Mary</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001023</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lance</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001023</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lance</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001030</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Kim</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001030</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Kim</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001030</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Kim</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001041</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Teresa</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001041</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Teresa</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001046</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Bob</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001046</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Bob</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>001053</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Susie</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT: #cccccc 1pt solid; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>012135</TD><TD class=xl64 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">Lori</TD><TD class=xl65 style="BORDER-RIGHT: #cccccc 1pt solid; BORDER-LEFT-COLOR: #cccccc; BORDER-TOP-COLOR: #cccccc; BORDER-BOTTOM: #cccccc 1pt solid; BACKGROUND-COLOR: transparent">3</TD></TR></TBODY></TABLE><!-- / message -->
Click to expand...
Try this...

Book1
ABC
2001014Mike1
3001014Mike1
4001016Sam1
5001021Mary1
6001021Mary1
7001023Lance2
8001023Lance2
9001030Kim2
10001030Kim2
11001030Kim2
12001041Teresa3
13001041Teresa3
14001046Bob3
15001046Bob3
16001053Susie3
17012135Lori3
Sheet1

Book1
EF
1MonthCount
213
322
434
Sheet1

This array formula** entered in F2 and copied down:

=SUM(IF(FREQUENCY(IF(C$2:C$17=E2,MATCH(A$2:A$17,A$2:A$17,0)),ROW(A$2:A$17)-ROW(A$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
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
619
smozgur
smozgur
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA code clean up
Replies
9
Views
574
mumps
mumps
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
F
  • Question Question
VBA Macro Issue: Replacing Simple Formula with Complex Formula Causes Error
Replies
2
Views
103
flashgordie
F

Forum statistics

Threads
1,224,547
Messages
6,179,436
Members
452,915
Latest member
hannnahheileen

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