-4
How to check in Excel if the value of a cell is repeated, row value in the same column,I did not make any command attempt. I would like to know if there is a specific formula?
1 answer
1
You can use conditional formats:
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Please read the Manual on how NOT to ask questions, How we should format questions and answers? and Be more specific in the question. So avoid using Capslock and put example values of a table, being more specific.
– danieltakeshi
Yes, excel has a button to remove duplicates in the data toolbar.
– bfavaretto
Ok. I didn’t want to remove it, but to signal that it is repeated. Is it possible? Conditional formatting?
– Rodrigo Sodre Dias
The last time I needed something like this, I ended up duplicating columns and creating formulas. As far as I know, there is no pattern and conditional formatting does not solve. Let’s wait to see if someone appears with a detailed answer (but already notice that Excel is not among the subjects most dealt with here, it may take a while).
– bfavaretto