Questions tagged [duplicate]
A duplicate is any re-occurrence of an item in a collection.
0
votes
0answers
7 views
How to remove duplicate emails in Office 365 OWA? [migrated]
We are using Office 365 and prior to this, we used Gmail. When I was using Gmail I had a filter by which I was moving emails from a particular account to a folder and also keeping a copy in the Inbox. ...
1
vote
2answers
34 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
102 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
52 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
90 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
62 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
19 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 ...
0
votes
3answers
85 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
34 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
2answers
573 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
12 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
17 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
2k 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
30 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
13 views
Preventing duplicates in drop down content control in WORD
I have a word form that has a section with a table in it. In one of the columns of the table, I am using a drop down content control. Is there a way to prevent a user from selecting the same value ...
0
votes
0answers
18 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
79 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
61 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 ...
1
vote
0answers
299 views
LEDE/OpenWRT router is duplicating ICMP and ARP responses for every VLAN
i have a problem with an AT-GS950/24 managed switch from Allied Telesys. I have configured several VLANs, and it is reporting its management IP via ARP on all VLANs, which is resulting in duplicate ...
0
votes
0answers
425 views
EXCEL: How to jump to first (or next) duplicate value in a sorted column?
I have a sheet with hundreds of thousands of rows. There are a few duplicates on the ID column. The technique to highlight duplicates does not work, as using the scroll bar shoots past them so fast ...
0
votes
1answer
50 views
Backup folder to group of devices
I have a mounted SD Card of 64Go, I would like to backup every pictures on it to multiple USB keys which are 32Go each with a simple script.
Is it possible to fill the first USB key and then continue ...
0
votes
2answers
205 views
Windows - keep (!) duplicate file names from different folders
All answers I find are about deleting duplicate files, but I want to keep duplicate file names (not files, they only have the same name).
I have been playing around with RAW photo processing software....
1
vote
2answers
42 views
Excel count of number of times a unique value has been selected
I have a long file with three columns, the first column contains the name of institutions, the second column contains the name of customers within each institutions and the third columns contains a ...
-1
votes
1answer
285 views
Similar warning to Can't install .NET 3.5 on Windows 10 [duplicate]
I did not have enough rep to answer or comment on the original question, but I wanted to contribute my findings.
See Can't install .net 3.5 on Windows 10 for the original question.
I received a ...
0
votes
1answer
779 views
Excel - Find duplicate values in two rows with two conditions
Could someone guide me to find the correct formula for this case of conditional formatting in Excel?
1- Highlight the two adjacent cells in orange only if their values are the same on the same line
...
2
votes
1answer
606 views
How to close duplicated data file in Outlook?
In Outlook 2010 I have only one account, which is for Gmail mail, using IMAP. So, my folder structure was like this - default Outlook folders and my Gmail account:
It was all working OK, until I ...
0
votes
0answers
37 views
Is there a way to remove all iTunes duplicates?
I have a long list of duplicates and it'd take a very long time to select them one by one and then remove them…
Does anyone know what I should do?
0
votes
0answers
422 views
Highlight Triple Entries in Excel
I am having a hard time here for what should be a simple query. Finding duplicate entries is really easy with the built in Find Duplicates under Conditional Formatting.
What I really want to do is ...
0
votes
1answer
213 views
Make lists of certain length using multiple other lists
I have a lot of relatively small files with about 350.000 lines of text.
For example:
File 1:
1. asdf
2. wetwert
3. ddghr
4. vbnd
...
264187. sdfre
File 2:
1. erye
2. yren
3. asdf
4. ...
8
votes
5answers
21k views
Start menu duplicate Shortcuts
After the last Windows update (Creators Update) I have a serious problem in the start menu...
Some shortcuts are duplicate.
So far I tried various methods without any luck:
Remove from start (I ...
0
votes
1answer
274 views
Finding and removing duplicate files of a specific file extension or type in OS X with a script? [duplicate]
Not sure why but there doesn't seem to be a utility app that allows defining a search and delete duplicates by file extension or type.
Is it possible to do through some terminal script? Like for:
...
0
votes
1answer
50 views
Excel Delete Rows with the same first number, but different 2nd value
I have an excel sheet with a few thousand rows of something similar to the following:
A1 B1
9-1 Apple
9-2 Pineapple
10-1 Grape
10-2 Orange
10-3 Pear
11-1 Lemon
Is there a VBA script ...
4
votes
1answer
3k views
remove duplicate lines without sorting
Is it possible to remove duplicated rows in Notepad++, leaving only a single occurrence of a line?
If I have these lines:
1
5
3
9
1
4
3
I want it to be:
1
5
3
9
4
I want it to keep first ...
1
vote
0answers
45 views
Excel: Expand list to include duplicates [duplicate]
I am trying to dynamically expand a list to include duplicates. I managed to achieve this without VBA, but after condensing several columns containing intermediary functions I have tied myself in a ...
0
votes
1answer
41 views
How to remove duplicate zeroes in multiple rows and columns in Excel?
Is there a quick way to remove 0's in multiple cells across columns and rows? I do not just want to delete the 0's but I also want to shift the values up after the 0's have been removed.
I have added ...
0
votes
1answer
2k views
Combine two rows into a single series in a line graph (Excel)
I am plotting a line graph in Excel and my data is as follows:
As you can see there are rows with the same name (an example is highlighted). How do I combine these into the same series? So I will ...
0
votes
0answers
52 views
Duplicate IP address in mtr output - LAN router being reported incorrectly
When trying to debug problems with my Internet connection, I found that when I run mtr I see that the address of my local LAN router (TP-Link TL-R860) is reported incorrectly,
% mtr -c 10 --report 8....
1
vote
1answer
2k views
Find all duplicates except the first one, then get values from a different column
A B
X1 16
X2 17
X2 18
X2 19
X3 21
I have two columns as above.
If there are duplicates in Column A (here the duplicate value is "X2"), then I ...
0
votes
1answer
46 views
Linux python scripting check for directory that have the same name but different case
Using an ntfs partition on an external hard drive on Linux, I would like to be able to rename directories that have the same name with different case in order to user the same disk on Windows.
The ...
5
votes
1answer
23k views
Duplicated Onedrive icon in explorer
I've installed windows 10 on a new pc, with a secondary hard disk containing my onedrive folder, taken from my old pc. I've configured onedrive in order to use that folder, and it's working fine.
The ...
1
vote
0answers
224 views
Outlook macro running twice
I use a macro to send an auto response to texts that come to my outlook. This works but it sends the reply to our customers twice every time. Any advice how to stop this. The macro is:
Sub ...
0
votes
1answer
415 views
Duplicate user “cryptoPolicy” in active directory 2012
Im moving Windows Server 2012 Essentials to a new hardware using this tutorial , in the best practice analyzer i found that i have 2 usernames with the same CN "CryptoPolicy" one inside Program Data/...
0
votes
1answer
343 views
Deleting/Highlighting Duplicate rows in Excel across multiple columns
I've been searching for a while but haven't really found an answer, so I thought I'd post.
I can't really write any codes, but I've tried using the following:
Sub DeleteDuplicate()
Dim current As ...
0
votes
1answer
4k views
How to identify 2 duplicate consecutive cells in Excel?
How can I identify duplicate consecutive cells, not in adjacent columns but adjacent rows like my sample below:
4/30/2016
5/12/2016
4/5/2016
5/10/2016
5/10/2016
4/30/2016
5/12/2016
5/10/2016
In ...
0
votes
1answer
63 views
How Do I Remove Duplicated From “This PC”?
As seen in the screenshot, "This PC" shows double "Desktop" Icons and missing the "Downloads" folder.
How do I get rid of the duplicate and restore the downloads folder?
-1
votes
1answer
109 views
How can I identify duplicate hostnames mixed with FQDN?
I have several thousand hostnames in a list. Some of these names are FQDN, and some are hostname only. How can I identify duplicates in this situation?
HostABC
HostABC.domain.com
The above are the ...
0
votes
1answer
37 views
how to remove Dupicates in particular cell in a excel
I want to remove duplicate. But that particular duplicate cells alone need to remove. I dont want to remove whole rows of that duplicate value. Do we have option for that in excel 2013.
For example:
...
1
vote
1answer
300 views
Match duplicate images by content and rename them (to the name of the duplicate)
I have 2 folders with over 5.000 photos each:
Folder 1: the original files in good quality but with human readable names (e.g. saigon_motorcycle_traffic.jpg)
Folder 2: the same files in really bad ...
1
vote
2answers
1k views
Recognizing duplicate values and adding them an extension automatically
I need a formula or a macro for Excel to do the next operations:
Identify the duplicates and leaving the first value as it is for example
2
2
2
2
2
2
Should become
2
2.1
2.2
2.3
2.4
2.5
This ...
-1
votes
1answer
87 views
prevent duplicates in excel is easy but
We all know how to prevent duplicates in excel by using data validation and the custom formula : =COUNTIF($A:$A;A1)=1 for example.
but I need to add a time condition, so every day I'm typing some ...
