{"id":4297,"date":"2025-11-11T10:00:00","date_gmt":"2025-11-11T10:00:00","guid":{"rendered":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/?p=4297"},"modified":"2025-12-01T10:38:24","modified_gmt":"2025-12-01T10:38:24","slug":"digitip-75-delete-those-duplicates-%e2%9d%8c","status":"publish","type":"post","link":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/2025\/11\/11\/digitip-75-delete-those-duplicates-%e2%9d%8c\/","title":{"rendered":"DigiTip 75 \u2013 Delete those Duplicates!\u00a0\u274c"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"3186\" height=\"750\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2025\/06\/digitips-banner_1750256831.png\" alt=\"\" class=\"wp-image-4253\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>If you\u2019re working in Excel and only want to count unique occurrences, or if you want a quick way to delete all appearances of a duplication then DigiTip 75 will solve your problem! Did you know that you can automatically delete all duplications simply by using the function Data &gt; Remove Duplicates. This will remove all duplications in the columns you selected.\u00a0\u00a0<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-background\" style=\"background-color:#ffb98759\">To follow our DigiTips,\u00a0<a href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/\" target=\"_blank\" rel=\"noreferrer noopener\">subscribe to our Digital Skills Blog<\/a>. Or alternatively, you can\u00a0<a href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/category\/digitips\/\" target=\"_blank\" rel=\"noreferrer noopener\">bookmark this webpage<\/a>, where a new DigiTip will be added each week!\u00a0\u00a0<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019re working in Excel and only want to count unique occurrences, or if you want a quick way to delete all appearances of a duplication then DigiTip 75 will solve your problem! Did you know that you can automatically delete all duplications simply by using the function Data &gt; Remove Duplicates. This will remove [&hellip;]<\/p>\n","protected":false},"author":75099,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[205,394,402],"tags":[215,464,194,329],"class_list":["post-4297","post","type-post","status-publish","format-standard","hentry","category-digitips","category-microsoft-excel-en","category-microsoft-support","tag-tipiaudigipa-digitipsau-en","tag-applications","tag-excel","tag-office365-en"],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/4297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/users\/75099"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/comments?post=4297"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/4297\/revisions"}],"predecessor-version":[{"id":4298,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/4297\/revisions\/4298"}],"wp:attachment":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/media?parent=4297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/categories?post=4297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/tags?post=4297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}