Questions tagged [duplicate]
A duplicate is any re-occurrence of an item in a collection.
255
questions
0
votes
0
answers
35
views
Using (Linux) iptables to drop duplicates?
Is there an easy way to use "iptables" rules to drop duplicate packets on Linux?
If not, I'll have to spend more time figuring out why the problem is happening. In short, it has to do with ...
0
votes
1
answer
219
views
MS Word Duplicate Page Numbering - same page number on facing pages for a manual
We use one document for both the trainer and trainee manuals. Trainer manuals include all pages, and the trainee manuals are printed from only the odd pages. It's a great solution for maintenance, but ...
0
votes
0
answers
289
views
Search Windows 10 directory for subfolders and files with common words in their names without specifying the words
Hard to explain! Please bear with me...
I rip my vinyl record collection to MP3 format. Each album gets its own folder. The naming standard I use for each album folder is "Artist - Album".
...
0
votes
0
answers
316
views
Remove duplicates in Excel, but always keeping the old value if a duplicate is found
I'm using Excel in Microsoft 365 Apps for Enterprise.
I need to paste new rows in an already existing sheet, then remove duplicates according to the value of the first column (the "name"). ...
0
votes
1
answer
41
views
Excel is duplicating part of my formula when moving sheets
Help please, I have a spreadsheet I created and use it to attach to other workbooks that has formulas to pull data from other sheets within the newly attached workbook. Problem is that when I open my ...
0
votes
1
answer
218
views
Windows 10 Pro randomly created another copy of C drive. What's going on?
I recently just noticed something strange. My C drive has somehow duplicated itself as the B drive.
Has anyone encountered this? How do I get rid of the B drive?
-2
votes
1
answer
59
views
How Does Duplicating Files To Reduce Read Time On Disks Work?
i recently looked into game files of a Sega Dreamcast game called "Tokyo Bus Guide", and i found a odd thing, there were tons of duplicate files!
when i researched on it and an Quora Comment ...
1
vote
0
answers
367
views
How to overwrite all files only if SAME size and exact duplicate while renaming if different size?
I'm using Teracopy, but Windows also does not have this function. Instead it wants me to replace the file only if DIFFERENT, or skip it if the name is the same. I want to do the opposite.
I need to ...
1
vote
2
answers
438
views
Duplicate Results from Batch File
I created a batch file that gives me the ability to input a computer name and it will tell me who is logged into the device as well as the serial number of that device. I pull these two specific bits ...
1
vote
2
answers
765
views
Can I find duplicate files with the same path in different locations?
I have two folders/directories: C:\MyData and C:\MyDataBackup and the person that owns those two folders/directories and does not remember if they have edited the files in the original or in the ...
0
votes
1
answer
147
views
Duplicate OneDrive Folders
I opended HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Desktop\NameSpace and there are no multiple file names under Namespace. I aslo seaarched for System....
0
votes
0
answers
184
views
How can I look for duplicate files from different base folders in bash?
I know fdupes, which can find duplicate files from various directories I provide it:
fdupes -r <directoryA> <directoryB> <...>
But this seems to “throw all files into the same ...
1
vote
1
answer
31
views
Deleting two points duplicate in Excel
I have this kind of dataset below
Point A
Point B
London
New York
Paris
Milan
New York
London
Madrid
Munich
Milan
Paris
...
...
In this case, I consider London to New York and New York to ...
1
vote
1
answer
41
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
57
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
903
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
2k
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
765
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 ...
1
vote
3
answers
3k
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
725
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
350
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
220
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
16k
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
43
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?
...
57
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 ...
4
votes
0
answers
3k
views
How to find dropped/duplicated frames in a video file?
I have some videos files where a few frames were missing. I can verify that by playing it in a video player and advance frame-by-frame, or by extracting all frames with ffpeg then check the output ...
1
vote
0
answers
182
views
Duplicate windows folders on different drives
I have seemingly redundant windows, users, program files, program files (x86) and programdata folders on two of my drives.
One drive is my bootdrive (C:) and the other is for storage only (D:). Both ...
0
votes
1
answer
17
views
Is Simultaneous Duplicate and Extend possible on a laptop?
My laptop is hooked up to a SmartBoard projector with a 9-pin cable. I've recently added a second monitor (HDMI). I can extend the monitor OR project to the SmartBoard - but have not been able to do ...
1
vote
2
answers
3k
views
Recognize, find and delete duplicate words in a txt or doc file
I received a few text documents with thousands of words in them (each word is in a line). I'm sure there are duplicate words and need to delete those duplicate and just remain a single of them. I copy/...
0
votes
2
answers
4k
views
Excel - Different highlighting for different pairs of duplicate values
0
I have an Excel file that contains the data of a website's users. In column A I have their username, and in column B I have their email address. Unfortunately, there are many duplicates: both inside ...
0
votes
2
answers
3k
views
pivoting unique values in excel
I have data with insurance policies and I want to pivot on the amount of policies sold per month.
A pivot table summarizes the count of the rows of the policies, even though there are duplicate ID ...
1
vote
0
answers
577
views
ICMP DUP! packets (but only sometimes)
I have LibreNMS monitoring devices on my home network and it is logging duplicate ICMP packets on my network.
Of the 30+ nodes being monitored, a few (3-4) exhibit this behavior. I can reproduce it ...
0
votes
1
answer
228
views
Excel 365: How to extract data from one sheet and automatically sort it WITH DUPLICATES
I have a small gaming table, of about 100 entries, with constant data updates.
Sheet: Officers
Name | Def | HP |
-----------------------
John | 10 | 50 |
-----------------------
Doe ...
1
vote
1
answer
2k
views
Excel Remove Duplicates - which occurrence is kept?
In Excel, when removing duplicate rows while ignoring certain columns (Data → Data Tools → Remove Duplicates → unselect ignored columns), some of the values in the ignored columns disappear entirely. ...
0
votes
1
answer
2k
views
User having duplicate folders populate on network drive
I have a domain user who is experiencing an issue in which folders in our "Share" drive will populate with a phantom folder, containing all of the contents of the original folder. For example:
...
5
votes
1
answer
2k
views
Filesystems that handle data-duplication efficiently and transparently
Are there filesystems that handle data-duplication efficiently and transparently for the user?
Example:
I have C:\documents\2019\bigfile.csv (250 MB)
I copy it to C:\temp\bigfile.csv, the used ...
0
votes
0
answers
6k
views
How to duplicate mouse cursor movement and clicks on windows?
Basicly what I'm trying to achieve is when moving my mouse I want to have second cursor duplicating everything I'm doing with my mouse ideally on second monitor or at least in second window or maybe ...
1
vote
1
answer
2k
views
Why am I getting seemingly duplicate “arp-scan DUP(:x)” results when running “arp-scan”
I have searched for the information but could not find an answer to my question.
So I ran this command on my laptop:
sudo arp-scan --interface=eth0 --localnet
And got some weird results:
ip ...
1
vote
1
answer
106
views
In Excel 2007, how do I remove duplicate lines, while merging data
To help you understand the question, here is a sample:
I have this:
Name - Account# - Address - . . .- phone
Mr. A . . 4278 . . . . 123 Main . . . 555-1212
Mr. B . . 7532 . . . . 435 ...
0
votes
1
answer
1k
views
How is a link-local address created when duplicate address detection fails in IPv6 Stateless Address Autoconfiguration (SLAAC)?
When Stateless Address Autonconfiguration (SLAAC) RFC 4862 is used to create a link-local address based on the interface identifier (Modified EUI-64), before the address is assigned to an interface ...
1
vote
1
answer
1k
views
Excel formula to average out numbers based on repetitive values
I have been trying to average out values in column 1 into the values as mentioned in column 2. For example if:
there are 10 12100 values, so individual average is 1210
There are 5 4550 values, so ...
0
votes
2
answers
2k
views
Excel formula for calculating average of duplicates
I have certain repeated values in the first column. I want to average out those values based on the number of times they are repeating themselves. I want the results in the adjacent columns.
...
1
vote
1
answer
1k
views
Laptop HDMI is duplicated on two screens, instead of extended across them
My laptop is a DELL LATITUDE 3004.
I was using it connected to two monitors (one in HDMI one in VGA). So I can work easily with my desktop extended on two screens.
Now I bought an HDMI splitter, so ...
0
votes
0
answers
22
views
Why are the contents of my Downloads folder duplicating to my account folder?
I just went to my C:/Users/[username] folder and noticed that every file that is in my downloads folder is also in my [username] folder. Why is that happening and how can I get this to stop?
0
votes
0
answers
69
views
Identical MAC addresses on Network updated [duplicate]
I have a network wired connected heatpump with a static IP address on my LAN, my son's Nintendo Switch has an identical MAC address.
Even though it connects via Wi-Fi from an access point, it refuses ...
8
votes
4
answers
4k
views
Identical MAC Addresses on Network
I have a network wired connected heatpump with a static IP address on my LAN, my son's Nintendo Switch has an identical MAC address.
Even though it connects via Wi-Fi from an access point, it refuses ...
4
votes
1
answer
2k
views
How do I delete BOTH lines of a duplicate pair in a text file in bash?
I want to delete both lines of a duplicate pair in a text file.
There is no way to do this using sort -u file or awk '!a[$0]++' file which both delete duplicated lines.
Somehow I would have to ...