Questions tagged [duplicate]
A duplicate is any re-occurrence of an item in a collection.
257
questions
1
vote
1
answer
48
views
How do I remove duplicates that have a difference of one word?
I have a folder with thousands of zip files, many of which are the same but for different countries. E.g. I would have three files called:
File 1 (USA)
File 1 (World)
File 1 (Europe)
How can I make ...
0
votes
1
answer
78
views
how do I compare dates separated by semicolon in same cell in excel
This is my data in column A. I want to compare dates with each other separated by semicolon to see if they all match or not and put the answer in another column saying match or no match. How do I do ...
0
votes
1
answer
1k
views
Cleanup duplicate mails after fetchmail messed up the fetchids list
I use fetchmail since years, to get my mails from a free private email provider, always with the "keep" option. Now, due to an update in mailu, the fetchids file got messed up and I have ...
3
votes
1
answer
3k
views
Remove duplicate AND original values, leaving only truly unique values in notepad++
How to delete both original and duplicate values in a notepad++ and keep only the truly unique values?
Say I had:
1
1
3
Desired:
3
0
votes
2
answers
874
views
Excel, Changing Values based on Duplicates
I have 3 columns on excel filled with previous data.
Column A is the name of employees [Jordan Smith]
Column B is the name of employees that clocked in on a certain day,this won't be added to the ...
2
votes
3
answers
4k
views
Microsoft To Do duplicate a task within list or a different list including task details
I have a template list on Microsoft To do. I want to be able to copy a single task within this list into another task (duplicate) then move it to wherever I need it and rename. Currently I can ...
1
vote
1
answer
811
views
EXCEL - How do I consolidate rows with duplicate information in one column but combine data in the other columns
Click to see example data
I have a spreadsheet of incoming products and the shipping containers they are arriving on. I want to combine rows with duplicate items while preserving the quantities of ...
0
votes
1
answer
2k
views
Outlook 2021, Cleanup & Find Duplicates
Hope everyone is well,
I have recently combined all my old pc backups and I have made a mess of my outlook pst data file.
I would like to get rid of all Duplicates including Duplicates that came to a ...
0
votes
1
answer
384
views
Automated Removal of Duplicate Folders (and contents of same) [Linux or Windows]
I have a number of folders and files on a Linux box that have been duplicated in a particular manner. The first level of folders are user names. Under each user folder, there are multiple project ...
1
vote
1
answer
1k
views
How to extract all files from a tar.gz with same names, but different content without overwriting repeated files
My tar.gz has multiple files with the same name but each file having different content ex: a.csv, b.csv, c.csv, a.csv, d.csv, a.csv and c.csv.
If I do
tar -xvf filename.tar.gz | wc -l
I'll get the ...
3
votes
1
answer
247
views
Which duplicate should I remove?
A while ago I somehow managed to duplicate a lot of photos but didn't realise till many months later and now don't know which one is the duplicate. For the duplicates, there is a common pattern ...
6
votes
5
answers
20k
views
Excel: how to duplicate every row into the same column?
Given a column like this in an Excel spreadsheet
aaa
bbb
ccc
...
How can I produce another column that looks like this (not manually copying and pasting of course since I have thousands of entries in ...
3
votes
0
answers
49
views
Find duplicate directory trees on a Mac
Sounds dumb, but actually, I'm not looking for single duplicate files (which is easily achieved via either specific programs or via command line tools like diff), but for complete directory trees (...
0
votes
1
answer
62
views
Remove duplicate entries on a column on the go [closed]
Other than removing duplicates using "Remove Duplicates" function on DATA tab, is there a formula or macro to delete/remove duplicate entries on the go so that I am left with unique values?
...
58
votes
8
answers
10k
views
How do I check if a 2-track WAV file is "really" in stereo?
I have an audio file (WAV format to be specific). When I open it with an editor (e.g. audacity), I see two channels I suspect that the recording is actually mono rather than audio, i.e. I suspect the ...