Highlighting duplicate column-pair and counting the rows Excel
Posted
by
pleasehelpme
on Super User
See other posts from Super User
or by pleasehelpme
Published on 2012-10-14T14:29:27Z
Indexed on
2012/10/14
15:40 UTC
Read the original article
Hit count: 246
Given the data below, the column-pair with the same values for at least 4 consecutive rows should be highlighted.
image here for better visualization: http://i49.tinypic.com/2jeshtt.jpg
2 2
3 4
3 4
3 4
3 4
2 3
1 2
2 2
3 3
3 3
3 3
3 3
2 3
2 3
2 3
2 3
2 2
3 4
3 4
3 4
3 4
3 4
The output should be something like this, where the column-pair values that are the same for at least 4 consecutive rows are highlighted.
image here for better visualization: http://i48.tinypic.com/i2lzc8.jpg
2 2
3 4
3 4
3 4
3 4
2 3
1 2
2 2
3 3
3 3
3 3
3 3
2 3
2 3
2 3
2 3
2 2
3 4
3 4
3 4
3 4
3 4
Then, I need to know the number of instances of the N-consecutive equal column-pair. Considering the data above, N=4 should be 3 and N=5 should be 1, where N is the number of rows that the column-pair is consecutively equal.
© Super User or respective owner