Find Duplicates with Excel
=COUNTIF(A$2:A$7;A2)
- A2: first line of values to be checked
- A7: last line of values to be checked
- "last A2" is the value, that is checked for and changes therefore in each copy of this ;-)
=>
=COUNTIF(A$2:A$7;A2)
=COUNTIF(A$2:A$7;A3)
=COUNTIF(A$2:A$7;A4)
=COUNTIF(A$2:A$7;A5)
...
#
0 Kommentare:
Kommentar veröffentlichen