Differences between revisions 1 and 2

Excel De-duplication

Contents

COUNTIF

A simple way to identify duplicates is to use the COUNTIF function.

Consider the following spreadsheet:

=COUNTIF($A:$A,A1)=1

Alternatively, to identify the unique cases and the first case of a duplicated set, try:

=COUNTIF($A$1:$A1,A1)=1

Alternatively, to mark the duplicate sequence of a case, try:

=IF(COUNTIF($A:$A,A1)>0,COUNTIF($A$1:A1,A1),"")

-  ⇤ ← Revision 1 as of 2022-03-09 15:59:22 → 
  Size: 588
  Editor: DominicRicottone
  Comment:
+   ← Revision 2 as of 2023-07-05 15:45:22 → ⇥
  Size: 714
  Editor: DominicRicottone
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 32:
+Alternatively, to mark the duplicate sequence of a case, try:

{{{
=IF(COUNTIF($A:$A,A1)>0,COUNTIF($A$1:A1,A1),"")
}}}