find the indexes of duplicates in 1D array

[Grey]

Hi,

I'm involving in a excel database project where i need a help.

I want to find the duplicates entries in 1D array and need to know indexes of them.

.

actually i have the 2D array with me,, i'm slicing column A of the 2D array and finding the duplicate entry's indexes.

Based on the duplicates indexes i want to modify the 2D array accordingly.

I googled and find some info but not able to solve still.

thanks.

[hooovahh]

Well this isn't a VBA or Excel forum, so you will likely find better answers elsewhere. If this is being done in LabVIEW it is quite easy. You use the OpenG Array package and use the "Remove Duplicates" function, which returns the indicies that were removed. Then you can use the Delete From Array providing a 2D array and then removing columns or rows, at the indicies found earlier.

[Grey]

Perfect.

OpenG helped me a lot.

in fact i came to know what is VIPM, Open G pallets and how to install.

great stuff to know.

thanks hooovahh!