Please help me with making a Multidimensional Array

To get it quickly can you send an XLS sample of the data

please see attached for a test fileTest file.xlsx

Thank you for your feedback. The logic I'm working on is just one step in a macro I'm building. I think a loop inside a loop is the only way to check each cell against one another to get ride of the dupes.

Try

Please Login or Register  to view this content.

Wow that's pretty cool!
The only questions I have are, how do I change the logic to delete the rows instead of just the cells? And can you put some comments in the logic so I better understand what's going on. I'm assuming ObjDic is a virtual table. I've never seen that command used before.
Thanks again!

The original purpose was "to write a multidimensional array" that was certainly why you were using "RowInfo()"
If you want to delete rows we can do it without the array: Please confirm.
About " put some comments " let's wait the final Procedure after the answer to the previous question
Concerning "ObjDic" it's an collection object, see for more detail:
http://www.snb-vba.eu/VBA_Dictionary_en.html (thank you snb)
http://www.experts-exchange.com/Soft...ss-in-VBA.html

Yes I would like to delete the rows that have duplicate cells. I'd also like to keep the array process incase I need to add another column to filter off of.
Hope that makes sense. And thank you for the links I will be checking them out.

See here after, of course some simplifications can be done versus the use of the array

Please Login or Register  to view this content.

That's perfect! Thank you.

Hey PCI, I hate to bother you again but I have to make what I think is a minor change to the code and for some reason Its not doing what I was expecting.
I had to add another column to check against.
What I'm looking to do is run the current loop until the data in column L changes. Basicly when cell 1 doesnt match the next cell down the loop would start over. This is so I don't delete repeats that are needed farther down the list.

I've attached test Data.
Here is the code after I added logic.

Please Login or Register  to view this content.

I'm not sure to get it right.
Previous macro is removing duplicate value, except when this value is "--------"
How this can be done only when value in column L is changing?
Can you send the final result you want from your file

Please see attached. The first tab is the input. Second tab is the output.
Thanks again for your help.

Thank you for all the hard work on this! The code is way past my skill level. Can you add some comments so I can understand what's going on. I was thinking you would have use column L as a trigger to start the loop over when the number changed.