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
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 27, 2010 at 09:29 AM
Related:
- Excel find triplicates
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 29, 2010 at 09:20 PM
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
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 27, 2010 at 09:29 AM
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.
Edit: Just noticed the date of the first post. Anyway the answer still stands.
Oct 27, 2010 at 08:40 AM