Get a Count of Duplicate Entries in an Array

Posted on February 14, 2013August 3, 2019 by Alan

This is a vbScript code fragment for something which took me a little too long to figure out. I am looking at a single dimension array and need to get a count of items in the array which are duplicates. I am comfortable with using the dictionary object and it seemed to be easier than using a recordset or a multidimensional array. So if your net search found this page, check out DisplayArrayDupeCount.vbs.

Update: 8/3/2019: The PowerShell equivalent is this:

$aDates = @("2/11/2013 11:10","2/11/2013 11:10","2/10/2013 10:59","2/11/2013 11:10",`
"2/11/2013 11:10","11/13/2012 12:52","2/11/2013 11:10","2/11/2013 11:10","2/11/2013 11:10",`
"2/8/2013 21:23","2/11/2013 11:10","11/13/2012 12:29","2/11/2013 16:51","2/11/2013 11:10",`
"2/11/2013 11:10","2/11/2013 11:10","2/10/2013 10:59","11/12/2012 20:51")

$adates | group-object -NoElement | where-object {$_.count -gt 1}

1 thought on “Get a Count of Duplicate Entries in an Array”

stubar says:

May 3, 2013 at 4:35 AM

Thank you, thank you, thank you. I registered to say that !
I knew it was possible but I was so far in the forest i could not see the trees :o(

You must be logged in to post a comment.

All the scripts are saved as .txt files. Newer files have a “View Script” button which will let you save or open a script in notepad. For earlier posts, the easiest way to download with IE is to right click on the link and use “Save Target As”. Rename file from Name_ext.txt to Name.ext.

To see a full post after searching, please click on the title.

PowerShell Scripts were written with version 3 or later.

https connections are supported.

All new users accounts must be approved, as are comments. Please be patient. If you find a post error or a script which doesn’t work as expected, I appreciate being notified. My email is my first name at the domain name, and you are welcome to contact me that way.

1 thought on “Get a Count of Duplicate Entries in an Array”

Leave a Reply