Finding duplicates/triplicates Excel

Closed
Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,

Please can anyone help?? I have a huge spreadsheet!! I have data in column A, B and C and the data is mad up of multiple spreadsheets brought into one master the problem I have is that multiple enters can come into this master eg: duplicates, triplicates or even bigger, see the same thing 4 times, 5times, etc, etc. I want to remove all the repeats or just pull out the unique records. Example below::
A B C
1 coat 27/8/09 10:00
2 coat 27/8/09 10:00
3 coat 27/8/09 10:00
4 coat 27/8/09 10:06
5 door 07/10/08 09.00
6 door 07/10/08 09:00
7 door 07/10/08 09:07

so from the above I want to keep one of row 1 to 3 and keep row 4, this can repeat over and over. and keep one of row 5 and 6 and keep row 7

Help please

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Easy way would be to concatenate all three column into one column, Just make sure you have a delimiter between columns. Then you can use Advance filter to have unique value moved to a new sheet and then split it back
0
This is not a good suggestion, neither a generic solution
0
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
creating a pivot table will achieve this.

Edit: Just noticed the date of the first post. Anyway the answer still stands.
0