Ask Your Question
0

Filter to only show duplicates

asked 2018-02-17 05:37:36 +0200

Alfred54 gravatar image

updated 2018-02-17 07:28:42 +0200

JohnSUN gravatar image

How can I show only duplicate entries by removing the first or unique entries. The list needs to be also date specific so it only shows duplicates with the same date. The required rows have an asterix *

8/02/2021   Bureau of Meteorology
21/02/2021  Bureau of Meteorology
20/06/2021  DepartmentofImmigrationandBorde
26/01/2021  Media Entertainment And Arts Allian
*26/01/2021 Media Entertainment And Arts Allian
*26/01/2021 Media Entertainment And Arts Allian
26/01/2021  Surelinc Services Pty Ltd
26/01/2021  Sth Western Sydney Inst
2/03/2021   HUMAN APPEAL INTERNATIONAL
19/04/2021  Ladies College
2/05/2021   LadiesCollege
13/05/2021  Ladies College
*13/05/2021 Ladies College
13/05/2021  Denten Supply Co Pty Ltd
24/05/2021  SydneyEnglishLanguageCentre
*24/05/2021 SydneyEnglishLanguageCentre
30/05/2021  PymbleLadiesCollege
9/06/2021   QHTextilesPtyLtd
9/06/2021           GeberitPtyLtd

Thanks for your help

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-02-17 07:38:09 +0200

JohnSUN gravatar image

updated 2018-02-17 07:42:46 +0200

Use a formula similar to this =COUNTIFS($A$2:$A2;A2;$B$2:$B2;B2)>1 in the additional auxiliary column

Doubles

edit flag offensive delete link more

Comments

Thanks JohnSUN for your help

Alfred54 gravatar imageAlfred54 ( 2018-02-18 08:18:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-02-17 05:37:36 +0200

Seen: 777 times

Last updated: Feb 17 '18