14,970
edits
Find and remove duplicates: Difference between revisions
Jump to navigation
Jump to search
→Marking Duplicate Titles with Sequential Numbers
| Line 21: | Line 21: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Row !! Title !! Formula (Sequential) !! Formula Result (Sequential) !! Formula Result (Flag Only) | ! Row !! Title !! Formula (Sequential) !! Formula Result (Sequential) !! Formula (Flag Only) !! Formula Result (Flag Only) | ||
|- | |- | ||
| A2 || Duplicate Title || =COUNTIF($A$2:A2, A2)-1 || 0 || (blank) | | A2 || Duplicate Title || =COUNTIF($A$2:A2, A2)-1 || 0 || =IF(COUNTIF($A$2:A2, A2)>1, 1, "") || (blank) | ||
|- | |- | ||
| A3 || Other Title || =COUNTIF($A$2: | | A3 || Other Title || =COUNTIF($A$2:A3, A3)-1 || 0 || =IF(COUNTIF($A$2:A3, A3)>1, 1, "") || (blank) | ||
|- | |- | ||
| A4 || Duplicate Title || =COUNTIF($A$2: | | A4 || Duplicate Title || =COUNTIF($A$2:A4, A4)-1 || 1 || =IF(COUNTIF($A$2:A4, A4)>1, 1, "") || 1 | ||
|- | |- | ||
| A5 || Duplicate Title || =COUNTIF($A$2: | | A5 || Duplicate Title || =COUNTIF($A$2:A5, A5)-1 || 2 || =IF(COUNTIF($A$2:A5, A5)>1, 1, "") || 1 | ||
|} | |} | ||