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

learn more… | top users | synonyms

0
votes
1answer
11 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
11 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
25 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
36 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
25 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
15 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
68 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
35 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
386 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
187 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
269 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
17 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
49 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
184 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
33 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
56 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
35 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
60 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
88 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
11 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
18 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
109 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
124 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
14 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
197 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
2answers
149 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
33 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
48 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
37 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
390 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
75 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
75 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
163 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
0answers
44 views

mv backup but instead of creating tilde directories, create tilde files in subdirectories?

I have 2 deep directory structures that are (probably) identical and I want to end up with a single one, but not auto-resolve existing conflicts (I'm guessing rsync would clobber something). I just ...
0
votes
1answer
223 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
89 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
580 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
368 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
66 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
659 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 ...
2
votes
3answers
13k views

How to remove non-duplicate records in Excel-2010

How do I 'Remove Non-Duplicates' keeping only the duplicate records? I know I can highlight duplicate records with a different color, but I'd prefer to remove the non-duplicates instead, as I don't ...
0
votes
0answers
126 views

Backup Folder with files but leave behind empty files/folders

I see this asked in linux and ubuntu forums/sites but could never find one for xcopy or Windows x86/64 platform (or an application) I wish to back-up a folder to another drive, but I would like to ...
0
votes
1answer
283 views

wget - Double downloads with query strings in URLs

I have to use wget to download, with the recursive option (-r), all the files in a web page. This page contains N direct links to the N files (http://xxx.xxx.xxx.xxx/page/File_n.abc), but also ...
0
votes
1answer
831 views

Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...
2
votes
0answers
66 views

SMTP Client implementation [closed]

I'm implementing SMTP client. What should the client do once it already sent the "." at the end of the mail, but didn't receive "250 Ok"? This is how the conversation between the client and server ...