How can I extract row of data (A:D) and write them in other columns
(F:H,J:L,N:P,R:T) of the same row.
Next I want to count the group occurences times and write the report to
a new sheet.
I have more than two thousand rows of data.

e.g.

A B C D E F G H I J K L M N O P Q R S T
1 2 3 4 1 2 3 1 2 4 1 3 4 2 3 4
1 2 3 7 1 2 3 1 2 7 1 3 7 2 3 7
2 3 4 5 2 3 4 2 3 5 2 4 5 3 4 5

etc........
Group 123 = 2 times
Group 234 = 2 times
Rest of the groups = 1 time.

Any help is appreciated.



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