Excel - check if row contains ANY value *more than once*

Posted by user2536778 on Stack Overflow See other posts from Stack Overflow or by user2536778
Published on 2013-06-30T16:18:51Z Indexed on 2013/06/30 16:20 UTC
Read the original article Hit count: 239

Filed under:
|
|

I am doing data analysis and sometimes I need to check and to make sure each row in excel does not have any repeated value. I hope that there is a formula where each time if there's a repeated value in the same row, the value will be highlighted and it doesn't matter what value it is, as long as it's repeated in the same row.

I try to search it everywhere but the closest I can find is below question & answer ( which couldn't apply to me as I need a formula that can highlight any value that's repeated and not only zero):

I have rows which contain grades for students (numerical values), where the number 0 means they missed a class. I want the row to be highlighted in one color if they have "0" 3 or 4 times, and in another color if they have "0" 5 times or more.

=COUNTIF(1:1,0)>=5

Anyone can help me? Thanks in advance!

© Stack Overflow or respective owner

Related posts about excel

Related posts about formula