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

3600243533 10873606 Z00205HE 3600243533 10873610 Z00205HE 3600243533 10873612 Z00205HE 3600243533 10873614 Z00205HE 3600243533 11239382 Z00205HE 3600243533 11239382 Z00205HE 3600243533 11239383 Z00205HE 3600243533 11239383 Z00205HE 3600243533 11239384 Z00205HE 3600243533 11239384 Z00205HE 3600243533 11239385 Z00205HE 3600243533 11239385 Z00205HE 3600243533 11239386 Z00205HE 3600243533 11239386 Z00205HE 3600243533 11239387 Z00205HE 3600243533 11239387 Z00205HE <colgroup><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.