jiura
04-14-2008, 07:53 AM
Hello to all!
I use Excel 2003 and I have an array of text data. This array consist of 15-20 text items in one column. I want to know has this array repeated text names or not. If I use Visual Basic with cycle in witch take?s the first name and then compare it with another?s, then take?s the second e.t.c. it ?s very long. How can I do it faster? If I only want to know has this array repeated text names or not.
I use Excel 2003 and I have an array of text data. This array consist of 15-20 text items in one column. I want to know has this array repeated text names or not. If I use Visual Basic with cycle in witch take?s the first name and then compare it with another?s, then take?s the second e.t.c. it ?s very long. How can I do it faster? If I only want to know has this array repeated text names or not.