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

learn more… | top users | synonyms

1
vote
1answer
24 views

Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
0
votes
0answers
9 views

Receive only 1 message when I'm listed as the recipient in 2 ways (Outlook 2013)

As a result of the following scenario, two identical emails appear in my Outlook 2013 inbox: to: my_email@my_work_domain.com cc: email_distribution_list@my_work_domain.com (which my email is ...
0
votes
0answers
20 views

Using a disk duplicator to copy multiple source disks to a single target disk

I know a disk duplicator(1:1) does a blind sector by sector copy, but if I put two disks together in a hardware JBOD enclosure, could I then remove each disk and place them one at a time in a disk ...
-2
votes
0answers
50 views

Copy data from 1TB SSD to 2TB HDD [with speed/cost constraints]

I have data being recorded to an external 1TB SDD at a rate of ~2GB/min. This occurs for multiple consecutive hours until the drive is full. Once that happens, the data needs to be offloaded to the ...
0
votes
1answer
54 views

Remove duplicate entries using bash, awk or sed

How can i search for duplicate data using batch? Goal is to remove duplicate "Changelist: XXXXX" entry from data.txt file. I'm kind of stuck, can somebody help me? Please take a look at output.txt ...
1
vote
1answer
46 views

CCleaner found thousands of duplicate system-related files. What do I do with them?

CCleaner found thousands of duplicate files. There are many different names, it looks like mostly DLLs and themes, that are scattered all over the computer. Their size varies anywhere from .8kb and ...
0
votes
1answer
25 views

How to add up Column B based on whether Column A is a duplicate value?

I have two columns, one with names and the other filled with '1'. Column A has many duplicates in it - this is intended - what I need is a formula to add the 1s in Column B if the corresponding values ...
0
votes
1answer
12 views

MS Excel - Unique name within the same column

This may be an already asked question, but unable to locate a solution that is suiting my needs... I have an Excel sheet of >24K entries. The Problem I have is the entries in a particular column are ...
1
vote
1answer
40 views

Excel: combine strings based on duplicate keys

I have two columns Key and Value (standard map) There are duplicated keys. It is trivial to delete the duplicated keys (namely the delete duplicates button). But that would delete some useful data in ...
2
votes
2answers
49 views

How can I duplicate a mac user account including username and password?

I have an account on my friends mac that I would like to move to my mac, so is there any way to duplicate everything in that account, including username and password? By the way, I am using OS X ...
0
votes
1answer
16 views

Search for duplicates in separate folders

I need to find duplicates (to delete) in two separate directories, and I was wondering if I could create a search function somehow to look for duplicate files. I could find them by copy/pasting one ...
0
votes
0answers
40 views

how to duplicate tab but maintain scroll position of web page

https://docs.angularjs.org/guide/directive has code samples. In each code example, there is a button (Edit in Plunker) that navigates the browser to a different site (Plunker). On that site I can ...
0
votes
1answer
25 views

How can I find and merge these duplicates from a list of 1000's of accounts with incomplete info?

How can I merge a list of companies with many duplicates but the duplicates aren't exact matches? Account # First Name Last Name Company Address City ST ...
0
votes
0answers
19 views

How can I prevent KDE double-starting Autostart apps?

My KDE is configured to restart the last session on login. Also, I have some application link(s) in ~/.config/autostart. What I'm experiencing is, of course, two instances of the auto-start ...
-1
votes
1answer
191 views

How to remove Open Office spreadsheet duplicates in a column while keeping rows together?

I have a spreadsheet with a list of column data of contacts, first name, last name, address, phone number, email... I want to remove the duplicate email addresses but the entire row may not have ...
0
votes
1answer
56 views

How Duplicate address is detected in lan for ipv4 networks

If i have two pc's connected to a switch , and i statically configure the same ip address on both the pc's, then how the pc's come to know that there is a address conflict (duplicate address) on the ...
-2
votes
2answers
625 views

highlighting duplicate rows in excel by VBA macro

I have a matrix which includes different/same values in first column, and different values in first row. I would like to compare all rows and highlight duplicate rows. For each row, it should check ...
0
votes
1answer
282 views

Microsoft excel 2010 - highlight duplicate values in multiple columns

I have been looking at a lot of help articles about how to highlight duplicate values, but I can't find one that does exactly what I am trying to do. I was hoping to highlight cells when the value in ...
0
votes
1answer
645 views

Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...
1
vote
1answer
19 views

Duplicate filename with _0001, but zero file size

I have, somehow, created many duplicates of some files, they end in _0001.php for example. I might have done this while trying to crete symbolic links. The sym links work, but I now have these files. ...
1
vote
1answer
56 views

Excel duplicates in one column based on another

Hoping someone can assist with this. We have a spreadsheet with data as below: A B C D E F G 777142 233 4 45151 te01-ccm 0 777303 233 6 45151 te01-ccm 0 ...
1
vote
3answers
235 views

Easy way to delete duplicate files in a folder in Windows 7

I have a folder with lots of images, where each image file has a duplicate file in the form abc.jpg and abc-1.jpg (where the latter is the duplicate file). Is there an easy way to select and delete ...
0
votes
0answers
41 views

Detect duplicate file name with different extension

I used Office File Converter (OFC) to convert my old Office documents to the newer format with a an X (docx, xlsx, pptx). OFC did not provide an option to delete converted documents. Now, I need to ...
0
votes
1answer
68 views

Comparing files in two folders with different hierarchies and renamed files

I had a folder on my PC, and copied it to my laptop. Since than, I have changed some files on each of the folders (file modification, renaming, putting into folders an vice versa). How can I re-sync ...
0
votes
1answer
39 views

Mail server that supports duplicate file detection?

AFAIK, Google mail servers (gmail) can detect duplicate files. For example, if you receive a big file as attachment that exactly exists in someone else's inbox, google avoids storing the file twice, ...
2
votes
1answer
78 views

remove duplicate lines after first word in sentace linux terminal

I was looking to remove duplicates of lines of text but after a space from the first word in this format; apples blue apples green apples are sometimes red pairs green pairs black potato brown lemon ...
1
vote
1answer
115 views

2 large text files, find the lines that are not duplicate linux terminal

I am looking to find lines that are not duplicate, example; Text file 1: cats 3 dogs 8 mice 4 pigs 10 ... Text file 2: dogs 8 mice 4 cats 78 pigs 29 bird 6 ... Cats and pigs simply got changed ...
0
votes
0answers
12 views

Duplicate subscriptions in iCalendar

I'm using iCalendar on my Mac and I have several subscription URL:s (for each course schedule) and one main URL for all the courses together.(without the context_id) But I can't have more than one ...
0
votes
0answers
20 views

Remove duplicate data for same week in Excel 2010

I pull a combined data for different employees for payroll and if they used R,3,X (codes for payroll). When I pull the data, the report duplicates the employees because if there is an R or 3 for the ...
0
votes
1answer
15 views

Duplicate images local search with different filename

Is there a software for searching duplicate images? I have huge galleries I can't go through by eye. And those images happen to have different names. I'm on win8.
1
vote
1answer
130 views

'Find Duplicate' function using in Sublime Text

So, the highlighduplicate plugin for sulbime text does not seem to work for me so I'd like to create my own. I need this to identity duplicates so it's a step further than Sublime's 'Permute: Unique' ...
0
votes
2answers
150 views

Win: Remove duplicate lines in huge txt file

I need to remove duplicate lines from a huge txt. The file is about 150 mb big. When I try PSPad, I get memory error (despite I have 8 GB RAM). Have you any idea or advice how to remove these ...
0
votes
0answers
15 views

check for duplicates across rows NOT columns

I have a very large list of names that I need to compare across ROWS - not columns. Smith, John Smith, John Doe, John Doe, Jon As you can see John Doe is spelled ...
1
vote
1answer
228 views

Remove duplicate lines in LibreOffice / OpenOffice Writer

I'm working on a text file in Writer which is basically a sorted list of words and phrases. It contains some duplicates I want to remove. Normally I would use a regular expression in Search & ...
0
votes
1answer
191 views

How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below Column 1 Column 2 ABC123 ABC123 CDE456 ABC123 EFG789 ...
0
votes
1answer
35 views

Using Mac Excel, How can I delete complicated duplicates?

I'm running Mac Office 2011 under Lion. I have a spreadsheet with headers of Company, Name, Last Name, City, State, and Email. Some are duplicate entries but are missing the email. I would like to ...
0
votes
1answer
49 views

How does Pop3 for multiple locations work? (Fetchmail)

I use POP3 and Fetchmail to download my gmail at home and on my work machine. But I've noticed that, although I'm using --keep to prevent it being deleted on the server, usually the messages I ...
1
vote
0answers
40 views

Merge duplicate text from two columns and put unique text in another column

I've got two columns of about 13,000 email addresses. One has members and the other has newsletter subscribers. There are duplicates between the two(ie. a member who also subscribes to the ...
1
vote
1answer
444 views

script to delete duplicate files using md5

I want to write a script to find duplicate files in a given directory and delete the copy depending on the hashcode. When I run the script it deletes the copy and the original file. Here's my code: ...
0
votes
0answers
33 views

Add “rename” to windows save duplicate dialog?

Error message Copy File There is already a file with the same name in this location. Click the file you want to keep. Copy and replace. Don't copy. Actual behavior When I download a file of ...
0
votes
1answer
80 views

New domain overwriting old domain accounts

Somehow I don't like how I titled this but oh well. What happened is I got hit with the IE bug on one of my servers which just happens to be my Domain controller and AD. So unfortunately I was ...
0
votes
2answers
78 views

Excel: deleting duplicate records based on an int value

In a sheet that has two columns, the first represents a string and the second represents some field value associated to that string as shown below. I roughly have 30,000 rows like that. My Question ...
0
votes
1answer
179 views

How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns). The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...
0
votes
1answer
234 views

Excel - How can I highlight duplicate cells in near-matching worksheets?

I'm running a March Madness bracket tournament using Excel spreadsheets. I have one sheet where I will input the actual winners. I have an additional sheet per participant that is near-identical, only ...
0
votes
1answer
33 views

Replace NTFS hardlinks with files

I deduplicated backup files on an NTFS partition. I would like to know if there is a way to reduplicate the files so that they can be edited individually. Currently /dir1/file1 /dir2/file1 -- hard ...
0
votes
1answer
91 views

Delete files which have almost identical filenames EXCEPT last word (Windows)

I'm trying to sort a directory of files with some conditions but I can't for the life of me figure this out. Here's a little example of some filenames which are to be sorted out (deleted). Turok 3 - ...
0
votes
1answer
656 views

Remove the (1) when saving duplicate files in Google Chrome [duplicate]

So when i save a duplicate file from the net, the system automatically adds a (1) right at the end, before the extension and I have no idea if I can change it. How do i keep the original file name so ...
0
votes
3answers
520 views

Duplicate textbox in powerpoint

I see the "Duplicate" button only for the slides. How do I find it for the textbox? Inkscape, for instance, has such option to create the new object right at the same place as the source object. This ...
1
vote
0answers
71 views

Deleting repeated emails in Thunderbird

I have a small pet peeve which I find really annoying and which I would like to find an automated way to not deal with repeatedly. I receive emails from two separate mailing lists, one of which tends ...
0
votes
2answers
718 views

Removing Duplicate Files With Powershell

Powershell Has been shipped stock since Windows Vista. I have many clients who download files, forget where they end up redownloading the same exact file. These files if they are duplicates are ...