Differences between revisions 2 and 5 (spanning 3 versions)
⇤ ← Revision 2 as of 2023-07-05 15:45:22 →
Size: 714
Editor: DominicRicottone
Comment:
← Revision 5 as of 2025-04-08 16:26:15 → ⇥
Size: 0
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
= Excel De-duplication =

<<TableOfContents>>

----



== COUNTIF ==

A simple way to identify duplicates is to use the [[Excel/CountIf|COUNTIF]] function.

Consider the following spreadsheet:

|| ||'''A'''||'''B'''||
||'''1'''||Alice ||1 ||
||'''2'''||Bob ||2 ||
||'''3'''||Charlie||3 ||
||'''4'''||Daisy ||4 ||
||'''5'''||Edward ||5 ||

{{{
=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),"")
}}}



----
CategoryRicottone