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

learn more… | top users | synonyms

1
vote
0answers
15 views

Windows 8.1 and a Sharp Aquos

I just bought a new Laptop with Windows 8.1 on it. My previous laptop had Windows 7 and was perfectly able to duplicate and display perfectly on my TV with a HDMI connection. After I updated that ...
0
votes
1answer
11 views

Show a duplicate value on seperate excel spreadsheet

I have an two excel spreadsheets. One of the sheets is a summation of what is on the other sheet. I need to have a cell on the summation sheet that will tell me if i have a duplicate (more than 3 ...
0
votes
1answer
41 views

How do I remove Windows that is not Installed?

Whenever I boot up my PC I get 2 options: Windows 10 (C:\Windows) - default OS and this is what I use Windows 10 (\Windows) - when I click this, it goes to a blue error screen saying that Windows ...
0
votes
0answers
18 views

How to find duplicates of files from set directory in other locations?

I cannot find solution to following problem: There are directories A, B, C and D (with subdirectories) containing lot of JPGs (photos). I want to compare directories B, C and D with A to ...
0
votes
1answer
36 views

How to identify duplicate combinations of two values in random order

I am trying to identify the second duplicate combinations of cells across two (or more) columns. Complicating matters, the order of combinations varies. My data looks something like this: aaa 111 ...
0
votes
0answers
13 views

To store wanted duplicates to fdupes locally and system-wide

I found today a great commandline tool fdupes which I describe here in Wiki page. You see that I have 2664 duplicates where some are wanted ones. I would like that the program remembers which files ...
0
votes
0answers
32 views

Duplicating sound from PC to TV via HDMI

tl;dr I want to duplicate aduio from my PC to my TV without delay/buffer. Though TV may have buffer, that's ok, but not my headphones. PC and TV are connected via HDMI, but Windows only lets me ...
1
vote
1answer
115 views

OFFSET Function in Excel just for non-duplicated data

I want to use OFFSET function to triple the data in a column. But I have some duplicated data (sometimes more than 2 repetition) that I want to just triple one of them not both and keep the other one. ...
0
votes
2answers
67 views

Generate list of duplicates in a column [closed]

I am trying to search a column of descriptions for duplicate items. The wording looks like so: alpha b122 bravo b134 epsilon b122 sigma b134 I would like to search for the duplicate b### within ...
0
votes
4answers
166 views

Excel: Sum values on a column based on criteria* on other columns *(complex criteria)

See below for rewrite. Please refer to the data below for the question. The very top A B C are columns and the far left numbers 1 through 15 are rows. The rest are cells. A B ...
2
votes
1answer
217 views

Excel 2013 Fuzzy Lookup to find near-duplicate text

I have a list of captions with a large number of near-duplicates. For example: Birthday for Her For Her Birthday Birthday - For Her For Her / Birthday I was looking into Fuzzy Lookup as a way ...
0
votes
0answers
63 views

Excel: Find duplicates among 2 colums

Giving an excel file with 2 columns: A: 5000 numbers (some repeated) B: 525 unique numbers I want to know if for each number in A there is a instance of that number in B. Meaning: for A1, is ...
0
votes
2answers
63 views

Undo Creating Symbolic Links by copying back the original, rename the file and deleting the link

I used a windows 7 utility to delete exact byte per byte duplicate files and replace them with a symbolic link before I knew that the symbolic link type is not allowed in our corporate domain. I need ...
0
votes
2answers
68 views

What is the difference between REN and RENAME?

I typed help into cmd and the following lines were part of the output: REN Renames a file or files. RENAME Renames a file or files. Next I typed help ren and help rename and got ...
0
votes
1answer
34 views

How can I return a count of a specific criteria in a range of duplicated items?

I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows]. I am looking for a formula that will return the ...
1
vote
1answer
384 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
21 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
28 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 ...
0
votes
1answer
113 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
69 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
39 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
29 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
116 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
196 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
19 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
89 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
38 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
30 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
401 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
223 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
1k 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
458 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 ...
1
vote
1answer
1k 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
22 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
89 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
578 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
68 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
109 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
63 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
99 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
254 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
21 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
17 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
244 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
527 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 ...
1
vote
1answer
314 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
262 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
42 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
62 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 ...