I have a worksheet contains 10,000 rows and columns A to H
The range is A1:H10,000.

e.g.
colums: A B C D E F G H

1) M N O P Q R S T

12) O P Q R S A B C

etc

33) A B P Q R C D E

44) A B D G H I J K

In the above example, row 1 will be hidden, row 12 will also be hidden,
row 33 will not be hidden.
This module will check present row against all the next rows in range
(A1:H10000) , if it find 5 or more cells are equal , then
the present row will be hidden and this will loop through the whole
worksheet. The value does not neccessary be in the same column.

e.g 2

a b c d e f g h
h g f e d i j k

the above example also treat as having 5 equal cell values.
Thank you for the help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/