CODEWITHSUNDEEP
excel
Cristian
Cristian

Reputation: 83

Check if a list have the same element in Excel

I would like to check if in Excel column I have two same element.
Basically my aim is to write every time a word in a new cell but I want excel to advise me if I already put the same word.

Something like this:
If I am writing again "dog" I want excel to tell me something.

enter image description here

Thanks in advance :)

Upvotes: 0

Views: 394

Answers (2)

jamheadart
jamheadart

Reputation: 5343

For Excel 2016

  • Highlight the entire column
  • Click on "Home"
  • Click on "Conditional Formatting"
  • Click on "Highlight Cells Rules"
  • Click on "Duplicate Values"
  • Click on "Ok"

enter image description here

Now enter dog in same column, both instances of "dog" will highlight red.

enter image description here

Upvotes: 1

iDevlop
iDevlop

Reputation: 25272

That's built-in!
See: Conditional formatting / highlight cell rules / Duplicate values

Upvotes: 1

Related Questions