vba compare arrays and remove exact matching arrays

[jacojvv]

Hi
I need help to create a vba that will compare all arrays to each other ,example listed below they are sepperated by 1 blank line and to remove any of them that have all 30 identical nrs in identical positions.(in this example the firs and last array are identical)

30 16 32 36 15 23
13 17 45 9 34 41
27 31 33 39 25 37
43 3 6 19 28 5
12 22 10 26 24 18

37 9 25 13 28 19
22 43 17 16 31 41
33 36 34 32 12 18
45 10 26 15 6 27
39 3 23 5 30 24

17 39 31 19 37 34
9 15 36 12 10 16
43 25 26 3 33 22
45 28 30 13 5 24
18 6 23 41 32 27

12 43 34 33 18 5
6 26 15 9 28 30
17 41 22 45 36 16
25 37 10 27 13 19
3 23 24 31 39 32

30 16 32 36 15 23
13 17 45 9 34 41
27 31 33 39 25 37
43 3 6 19 28 5
12 22 10 26 24 18

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[jacojvv]

ok ive uploaded a mocup with a Include a BEFORE sheet and an AFTER sheet

[:) Sixthsense :)]

Try the below code…

To Add Excel VBA Code to a Workbook / This Workbook Module

1. Copy the code that you want to use
2. Select the workbook in which you want to store the code
3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
4. In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
5. Right-click on the ThisWorkbook object, and choose View Code
6. Where the cursor is flashing, choose Edit | Paste

Please Login or Register  to view this content.

[jacojvv]

Hi
Exactly what i needed thank you

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

[MickG]

Cross posted Here !!!!
http://www.mrexcel.com/forum/excel-q...ng-arrays.html

[jacojvv]

ok found a bug..it only does up to 179 line where i currently have 19344
could we let it loop all the way down

[nilem]

Hi jacojvv,

in your example file on sheet "After" 1st and 5th arrays are not the same?

[jacojvv]

Hi
That is correct..the vba needs to search through the "before"sheet and remove any arrays that are identical(30 numbers in exactly the same positions)
then i will end up with a set of unique arrays on the "äfter" sheet. the same numbers are used but their positions in the array are different...i just want to remove duplicates basically

[nilem]

I may be mistaken, but take a look at the attached file
Are there any differences in the 1st and 5th arrays on sheet "After"?

[jacojvv]

Hi
the sheet after is what it should look like when the vba has completed running and removing duplicates.
the sheet "before" is where the examples are of duplicates.

[jindon]

See if the attached works.

[jacojvv]

Hi jindon
This seems to work much better thank you..will keep you posted

[jacojvv]

See if the attached works.

Hi

Ok it worked once...now on trying it with actual data it seems to not work

[jindon]

Bad luck and no idea about the file that I don't see.