count duplicates in column
Hi,
I want to create a macro that displays the index number of duplicates of column A in column B. So one column after the second "abraham" should display "2", one column after the third "abraham " should display "3", etc.
Any input is much appreciated!
Last edited by MaartenRo; 03-17-2021 at 01:01 AM.
B2:
=REPT(COUNTIF(A$2:A2,A2),COUNTIF(A$2:A2,A2)>1)
copy down
Somehow it doesn't work. I have a dutch version of Excel. Is there a way to do it with a macro?
Replace comma with a semi column.
=REPT(COUNTIF(A$2:A2;A2),COUNTIF(A$2:A2;A2)>1)
Please Login or Register to view this content.
Last edited by jindon; 03-17-2021 at 05:34 AM. Reason: Your ORIGINAL file attached
=COUNTIF(A$2:A2,A2)
copy down...
this is also going to work.
Shashank Mishra
Please hit "Add Reputation" Button if you liked the answer.
Please Login or Register to view this content.
No, no, no, no
Original question was not like that, see the attachment in my post #4 that was originally uploaded by the OP in his initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks