Excel - check if row contains ANY value *more than once*
- by user2536778
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!