Questions tagged [duplicate]
A duplicate is any re-occurrence of an item in a collection.
228
questions
0
votes
0answers
21 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:
...
3
votes
1answer
32 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
0answers
48 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
0answers
22 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
votes
0answers
20 views
Does Google actually duplicate files? [migrated]
When I duplicate a file in Google Drive (click "Make a copy"), is it actually duplicated on their servers? Or is it just a softlink to the original file?
1
vote
1answer
30 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
1answer
47 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 ...
0
votes
0answers
57 views
Google play music: how to find duplicate songs
I have uploaded thousands of songs on google play music. Most of them are not available on their library, some instead are available.
I would like to clean up things, therefore I need a tool or a ...
1
vote
1answer
31 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
2answers
46 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
1answer
46 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
0answers
16 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
0answers
10 views
Identify pseudo-duplicate rows with conditionals
I want to write a function that identifies rows that are "pseudo-duplicated" in my dataset, and returns unique values and de-duplicates applicable records.
The rules for a pseudo-duplicated row are:
...
0
votes
0answers
26 views
Duplicate tasks in Outlook To-Do Bar
Something has happened, and now all of my tasks are duplicated in the To-Do Bar of my Outlook Calendar. Adding a new task creates TWO, and deleting a task (or marking it 'complete') removes BOTH of ...
0
votes
0answers
56 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
4answers
2k 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 ...
1
vote
1answer
76 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 ...
0
votes
1answer
176 views
How to find duplicate id entries in a xml file
How can I quickly narrow down duplicate id entries in a xml file, example:
<entry id="A">...
<entry id="B">...
<entry id="A">...
and output them
id="A" dup 2 times
Just to let ...
2
votes
2answers
40 views
How can I move only 1 application to second display in Windows 10?
While using Windows 7, I was able to "connect to a projector" (second monitor), and choosing Duplicate, I was able to move only my preferred application to the second monitor. When I choose duplicate ...
0
votes
1answer
61 views
duplicate records, keep one with special condition
i have duplicate records in excel sheet , with only one different column (it is a number between 11 to 19)
i need to keep one of the duplicates with the lowest number in different column, for example ...
0
votes
1answer
43 views
transferring files without duplicate
Lets say I am hosting servers where users put files and at the end of the day all these files are retrieved into a storing server.
The problem is that lots of those files will be duplicate and I want ...
0
votes
1answer
222 views
Always choose larger file for duplicate downloads in Jdownloader2?
I am downloading a very large number of image links in Jdownloader2 (hundreds at a time.) It has to parse each URL to get the images, and it always finds thumbnails as well, which have the same ...
0
votes
0answers
20 views
When open excel file extended/duplicate display goes off
We have a large Panasonic TV at work - I connect my DELL laptop to it to share my screen during meetings. My laptop display has been duplicating to the TV automatically when I connect the TV cable to ...
0
votes
1answer
90 views
sed/awk: remove similar lines after first occurrence
i have:
constant1apple_____constant2asdfkjo___constant3
constant1apple_____constant2fdlkjef___constant3
constant1watermelonconstant2sdlfkeio__constant3
constant1banana____constant2asdfoie___constant3
...
0
votes
1answer
111 views
Identifying and sorting duplicates in Excel
I have a list of values in column A. Some of the values occur once, some occur twice, some occur more than 2 times. In column C, I would like to only list the values from column A that are repeated ...
0
votes
0answers
62 views
Large index match with multiple criteria, duplicate values error
I'm trying to return values based upon multiple criteria. I've tried everything I can think of to get this working but I must be missing something!
The formula I have which works so far is:
{=INDEX(...
0
votes
0answers
25 views
VBA Excel compare values from 2 workbooks and add duplicate position from 1st workbook into 2nd workbook
I am a newby on the VBA coding but very exicted to learn more. Unfortunately with my following problem I don't even know where to start. Hopefully someone can give me some directions.
Problem:
...
0
votes
1answer
643 views
How do I disable the double mouse cursor in Teamviewer?
I'm seeing a double mouse cursor when using TeamViewer. It happens whenever I move the mouse. It's like there's a mouse trail or a slow mouse. Why is it that? How do I get rid of it?
0
votes
1answer
38 views
Deleting Repeated cells
I am comparing 2 columns in WPS spreadsheet using the 'Highlight Duplicates' option. Once it is highlighted, if I use remove duplicates it isn't deleting the duplicates. If i manually delete the ...
1
vote
0answers
427 views
Microsoft Excel Fuzzy Lookup add-on - set too big?
The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...
0
votes
0answers
23 views
How to remove duplicate in batch by calling another script / utility / program
i'm looking for a way to remove duplicate pictures via a batch file, but after asking on stack overflow, it turned out not to be doable without using external utility or software.
So i'm asking here, ...
2
votes
1answer
605 views
One IP address has multiple MAC addresses, how is this possible?
While looking for duplicate addresses with the following command, "arp-scan --timeout 1000 192.168.110.0/24", I discovered that the host I'm running this command on has multiple MAC addresses for the ...
1
vote
2answers
94 views
Filter for Duplicates or Highlight Unique Responses Across Multiple Columns in Excel
I am trying to filter or highlight the results of a Survey with lots of response options, some of which repeat.
E.g. List your favorite animals
Name B C D E F
Bob ...
42
votes
3answers
6k views
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
If I let Excel highlight two duplicate values PT_INTERNAL2859736, then also unique value *736 gets highlighted. Why this happens and how can I stop highlighting the unique value as duplicate?
I ...
1
vote
2answers
326 views
Find duplicate WEBM files
I have a large collection of files in webm format. Some of them are duplicates. They have totally different names, but their content is the same. It is annoying to find them by myself and then delete ...
1
vote
1answer
2k views
How to delete same lines in Notepad++?
I want to find out if there are any extra files between a long list of files that I generated. Because I`m weak at explaining stuff with words, I'd rather illustrate.
This is an illustration of the ...
0
votes
1answer
54 views
Formula to select/output the preferred row based on a values proximity to another value
I'm working with a large building footprint data-set that was joined to Parcel data based on geographic location. This Building Footprint data-set has multiple footprints within the same parcel and ...
-1
votes
1answer
775 views
Compare contents of two folders by Hash to find duplicates
I have two folders containing various files. These files don't have the same filename or the same creation Date. They may be identical though as far as the actual file is concerned.
I executed a ...
1
vote
0answers
115 views
Excel: why do “remove duplicates” and “conditionally highlight duplicates” give different results?
Obviously these tasks do different things! But I am using them to find out if I have duplicates :)
In excel I have a column which is a concatenation of all of the other columns.
(The formula is ...
0
votes
1answer
24 views
Identifying duplicate rows by certain columns and removing
I have sql results of 9000k rows and > 10 columns. I need to remove rows as dups that has another row that matches 4 of the columns (not an exact dup row). I've researched and tried various things but ...
1
vote
3answers
855 views
Combine unique cell values on a single row
See below image of my 3 inputs (columns A:C) and expected out put (column D),
I would like to list the unique values for each row as an output, separated by a comma.
0
votes
1answer
73 views
File and folder mirroring required, to work on multiple systems
I am a graphic designer and I work on multiple systems, an imac at my office, and a laptop at home. i generally work on one system and then continue the work on other system, and more frequently i ...
2
votes
3answers
4k views
Does Outlook's “Replace Duplicates” export option affect the source mailbox?
I have not been able to find any good explanations of which of the following options to choose when exporting a full email account to a .pst backup (that would eventually be loaded as a data file on a ...
0
votes
0answers
41 views
Merging duplicate rows Excel but keep Max / Min dates of associated fields
I need to merge duplicate rows based on Name and Arrival Date/time but keep
Min(Start Date/time) and Max(End Date/time) of associated rows in final row.
My Spreadsheet
0
votes
0answers
28 views
Errors in Moving Data Files to D:\
Errors in Moving Data files to D:\
I am running win pro Evaluataion copy Build 17713.rs5_release 180706-1551 –
I am setting up a new laptop, so I have no real data on the new machine at this time.
...
3
votes
2answers
11k views
Return a “one” for the first instance of duplicate values and a “zero” for the other instances
I'm trying to write a formula to check for duplicates in one column.
It should return a 1 for the first instance of the duplicates and a 0 for the other instances. If the value doesn't have a ...
0
votes
1answer
36 views
Find duplicate settings in dotfiles
I have copied some dotfiles settings, mostly from github, into my own dotfiles. Now I have the problem that some settings are duplicated and have same or different values. E.g. in Xresources:
...
0
votes
0answers
21 views
Find files with duplicate names on MacBook
I have uploaded 11,000+ files to Dropbox, but I only see 8000+ of them. I realized it was because Dropbox automatically replaces the files (with older timestamp) with the new files that are with the ...
1
vote
2answers
397 views
remove duplicate values from two spreadsheets in excel
I have got two different spreadsheets with some duplicate emails in it but maybe with different information in other cells of the same line. Both of the spreadsheets contain more than 10k lines. I ...
1
vote
1answer
91 views
How to delete filenames with similar partial name?
I have a bunch of filenames that are timestamped (down to the nanoseconds) and I only want to keep one file per second.
For example, here are some file names:
11-14-29-033.jpg
(which means that the ...
