Count duplicate value on first available

[imran ashraf]

Column A

Ali

Ali

Imran

Waqas

Imran

Ali

<tbody>
</tbody>

please help i need to count in column B duplicate value of first available Example : Ali (3) the count value just show on first available Ali remaining should be Zero .

 

[alansidman]

Here is a vba solution for you.

Option Explicit


Sub ashraf()
    Dim i As Long, lr As Long, x As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Application.ScreenUpdating = False
    x = 1
    For i = 3 To lr
        If Range("A" & i) = Range("A2") Then
            x = x + 1
        End If
    Next i
    Range("B2").Value = x
    Application.ScreenUpdating = True
End Sub

 

[Aladin Akyurek]

Is this the results you are looking for?

Ali
Ali
Imran
Waqas	1
Imran	2
Ali	3

<tbody>
</tbody>