Skip to content

Instantly share code, notes, and snippets.

@alexkadis

alexkadis/Excel - Highlight Duplicates, Case Sensative

Created November 21, 2016 22:02
Show Gist options
  • Save alexkadis/599e61d0a4f769afce6bc04d431dfcfb to your computer and use it in GitHub Desktop.
Save alexkadis/599e61d0a4f769afce6bc04d431dfcfb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Excel - Highlight Duplicates, Case Sensative
=AND(D1<>"",SUMPRODUCT(--(EXACT(D1,$D$1:$D$1495)))>1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment