Previous Topic Next Topic

Finding duplicates/triplicates Excel

Closed
Ab - 26 Jan 2010 à 14:49
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 27 Oct 2010 à 09:29
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
Related:

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
29 Jan 2010 à 21:20
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
Jani Basha
27 Oct 2010 à 08:40
This is not a good suggestion, neither a generic solution
Réponse 2 / 2
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
27 Oct 2010 à 09:29
creating a pivot table will achieve this.

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses