Skip to content

Instantly share code, notes, and snippets.

@ammar0466

ammar0466/excel

Created October 15, 2018 06:06
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ammar0466/495930b465fec60a628b86ff135a1675 to your computer and use it in GitHub Desktop.
Save ammar0466/495930b465fec60a628b86ff135a1675 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
excel
Compare 2 columns to find duplicates using Excel formulas
https://www.ablebits.com/office-addins-blog/2013/09/05/compare-two-columns-remove-duplicates/
=IF(ISERROR(MATCH(A1,$B$1:$B$10000,0)),"Unique","Duplicate")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment