Count Order Numbers and Line numbers based on Person who entered

[marty31]

HI

I am trying to calculate the line count of each person based on below info.

Col A is Order Number which can have same number(This needs to be a single reference), then tally the line count Col B) based on order number and person who entered the data (Col C).
Ie small example below, result would be 1 x Order with 16 x Line count By the 1 Person

Any help would be greatly appreciated
A B C
[TABLE="width: 396"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"][TABLE="width: 424"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"] 10873606[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]10873610[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]10873612[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]10873614[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239382[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239382[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239383[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239383[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239384[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239384[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239385[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239385[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239386[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239386[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239387[/TD]
[TD] Z00205HE[/TD]
[/TR]
[TR]
[TD="align: right"]3600243533[/TD]
[TD="align: right"]11239387[/TD]
[TD] Z00205HE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JLGWhiz]

VBA solution

Sub t()
With ActiveSheet
    .Range("A1", .Cells(Rows.Count, 1).End(xlUp)).AdvancedFilter xlFilterCopy, , .Cells(Rows.Count, 1).End(xlUp).Offset(2, 1), True
        For Each c In .Cells(Rows.Count, 2).End(xlUp).CurrentRegion.Offset(1)
            If c <> "" Then
                .Cells(Rows.Count, 5).End(xlUp)(2) = CStr(c.Value)
                .Cells(Rows.Count, 5).End(xlUp).Offset(, 1) = Application.CountIf(Range("A:A"), c.Value)
            End If
        Next
    .Cells(Rows.Count, 2).End(xlUp).CurrentRegion.ClearContents
End With
End Sub

Puts results in columns E and F starting on row 2.