Previous Topic Next Topic

Finding duplicates/triplicates Excel

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

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

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

Similar discussions

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

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses