if condition finding same numbers in consecutive rows

Hi guys I have a table with 120 rows and 5 columns. I want an if condition: if the table contains at least two consecutive rows in columns 2,3,4 and 5 which have the same number then write similar table, else do nothing.

Thanks for your help

[Jan]

What exactly is a "table"? On paper, Excel-File, csv-file, matrix in Matlab, a table object? Does "write a similiar table" belong to the problem and if so, what exactly is "similar"?

Answer 1

[Chad Greene]

You can use diff.

x = [4 5 2 17 17 3 4 2 2 4]; 
ConsecutiveNumbersStartAt = find(diff(x)==0)

[AA]

Good idea but i need it across columns and rows, ie.

55555
55555

Answer 2

[Jim Hokanson]

sum the differences, but make sure to take the absolute value so that you don't get positives and negatives that cancel out

find(sum(abs(diff(x,1,1)))==0)

Answer 3

[Chad Greene]

You can use the index outputs of unique with the 'rows' option. That'll give you indices of all the unique rows. Then the redundant rows are what's left over.

[AA]

I tried it but it is not what i wanted. Consider the following numbers

2 7 6 7 4 3 7 8 8
5 7 7 7 4 5 7 8 3
3 3 3 3 3 3 3 3 3

I want to find the last row where all the values across all columns are the same, i.e. lots of 3s. Plz help