Column A have many ID, there are duplicate value such as cell(A2) ID 300502489400, cell(A3) ID 300502520900, cell(A4) ID 300502520900, cell(A5) ID 300502520900, cell(A6) ID 300502523900, cell(A7) ID 300502520900,
i need to count number of duplicate and report in Column B
result such as
cell(B2) =1, cell(B3) =4, cell(B4) =4, cell(B5) =4, cell(B6) =1, cell(B7) =1,
how can i code VBA in excel?
I think it should loop to bring value in each row compare to all value and count.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…