Selecting specific rows from imported excel spreadsheet data

[Akib Khan]

Dear All,

I have imported data from an excel spreadsheet which looks like this:

table 1
a	b	c	d	e
1	3	1	3	5
4	4	4	4	7
5	2	5	2	2
6	2	6	2	3
table 2
a	b	c	d	e

Note that this is only an excerpt but the pattern repeats itself in the data-set. Now my query is: How do I code to keep data only from the red-shaded rows? Variable names are not a concern for this exercise. Please assume that they are var1, var 2 and so on.

Thanks in advance!

[Abbas Raza]

Could you explain what is the pattern you are trying to capture? Are you trying to keep only those entries who are repeating more than once in a row? or something else? Please clearly define the pattern you are trying to capture.

Thanks.