Questions tagged [duplicate]

A duplicate is any re-occurrence of an item in a collection.

Filter by
Sorted by
Tagged with
0 votes
1 answer
15 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 ...
user avatar
  • 3
0 votes
1 answer
21 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 ...
user avatar
0 votes
1 answer
102 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
user avatar
0 votes
2 answers
50 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 ...
user avatar
0 votes
1 answer
232 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 ...
user avatar
1 vote
1 answer
75 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 ...
user avatar
0 votes
1 answer
77 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 ...
user avatar
0 votes
1 answer
40 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 ...
user avatar
0 votes
1 answer
211 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 ...
user avatar
3 votes
1 answer
56 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 ...
user avatar
0 votes
0 answers
20 views

Identifying entire duplicated rows

I have a data sheet with 15 columns and 16,000 rows. I need to identify which entire rows are the exact same, not just rows with certain cells that are duplicates. When I try to apply conditional ...
user avatar
2 votes
4 answers
477 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 ...
user avatar
  • 353
3 votes
0 answers
33 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 (...
user avatar
  • 131
0 votes
1 answer
48 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? ...
user avatar
55 votes
7 answers
6k 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 ...
user avatar
  • 7,302
1 vote
0 answers
259 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 ...
user avatar
  • 23k
1 vote
0 answers
28 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 ...
user avatar
0 votes
1 answer
14 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 ...
user avatar
1 vote
2 answers
690 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/...
user avatar
0 votes
2 answers
650 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 ...
user avatar
  • 1
0 votes
2 answers
28 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 ...
user avatar
1 vote
0 answers
157 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 ...
user avatar
0 votes
1 answer
61 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 ...
user avatar
  • 161
1 vote
1 answer
244 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. ...
user avatar
  • 874
0 votes
1 answer
348 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: ...
user avatar
  • 1
3 votes
1 answer
44 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 ...
user avatar
  • 1,656
0 votes
0 answers
3k 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 ...
user avatar
  • 1
1 vote
0 answers
578 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 ...
user avatar
  • 111
1 vote
1 answer
42 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 ...
user avatar
0 votes
1 answer
391 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 ...
user avatar
1 vote
1 answer
406 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 ...
user avatar
  • 11
0 votes
2 answers
661 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. ...
user avatar
  • 11
1 vote
1 answer
458 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 ...
user avatar
0 votes
0 answers
18 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?
user avatar
  • 101
0 votes
0 answers
66 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 ...
user avatar
  • 91
8 votes
4 answers
3k 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 ...
user avatar
  • 91
2 votes
1 answer
637 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 ...
user avatar
1 vote
1 answer
2k 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 ...
user avatar
2 votes
2 answers
285 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 ...
user avatar
0 votes
1 answer
67 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 ...
user avatar
1 vote
1 answer
317 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 ...
user avatar
  • 119
0 votes
1 answer
618 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 ...
user avatar
1 vote
1 answer
297 views

sed/awk: remove similar lines after first occurrence

i have: constant1apple_____constant2asdfkjo___constant3 constant1apple_____constant2fdlkjef___constant3 constant1watermelonconstant2sdlfkeio__constant3 constant1banana____constant2asdfoie___constant3 ...
user avatar
0 votes
1 answer
210 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 ...
user avatar
  • 1
0 votes
0 answers
94 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(...
user avatar
1 vote
2 answers
3k 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?
user avatar
  • 877
0 votes
1 answer
260 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 ...
user avatar
  • 3
1 vote
0 answers
941 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 ...
user avatar
0 votes
0 answers
28 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, ...
user avatar
2 votes
1 answer
3k 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 ...
user avatar
  • 21

1
2 3 4 5