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

learn more… | top users | synonyms

0
votes
1answer
11 views

How do I do separate tasks on multiple screens which are duplicated? [closed]

I have multiple monitors and have duplicated the screens, but how do I do separate tasks on each screen?
1
vote
2answers
46 views

Find/check redundant files for cleanup and backup purposes

Very often I want to find out if the contents of given folders match or if the content of a single folder is redundant - maybe to check if it's duplicate and can be removed or to make sure there are ...
-1
votes
1answer
22 views

Does cloning duplicate data fragments?

If I have a fragmented hard drive, will duplicating the drive recreate the data fragments? Or does the duplication process clean those up? Does it depend on the duplication tool?
2
votes
1answer
23 views

How can I use conditional formatting or a macro to italicize duplicates (but not the original) cells?

I have a spreadsheet in which there are many duplicates (intentionally), and I would like to highlight the duplicates but not the first instance of a cell. Below is an example row: A A A A A B B B C ...
-3
votes
2answers
41 views

need duplicates with the merged header column

i need urgent help in terms of data duplication. given the data below, i want first sequence to be repeated twice. in short i want 2nd and 3rd column to merge along with the first column. it doesnt ...
0
votes
1answer
42 views

Find duplicate file in another directory

I have a file named: f{number}.ext In another directory there exists a list of dirs: 001 002 003 .... Each of these dirs contains a list of files: f001.ext f002.ext ... The file names are ...
1
vote
1answer
61 views

Find duplicates, update database with minimum value in Excel

`Sub Update_data() Dim Bk1 As Workbook Dim Bk2 As Workbook Dim Rng1 As Range Workbooks("Book1").Activate 'indicate wb name1 here Set Bk1 = ActiveWorkbook Workbooks("Book2").Activate 'indicate ...
3
votes
2answers
88 views

How to hide other team member's calendar entries if I have them too?

Since I'm displaying the calendars of other team members, I see appointments where more than one of them (including me or not) participate for every participant. Is there any way to visually merge ...
6
votes
1answer
438 views

Dropbox created a duplicate of all files, with “._” in front of each file name

I'm having a problem with dropbox. I've recently added a user to 2 of my dropbox folders (for group works), and from then all files uploaded by anybody in those folders are "duplicated" (just once) ...
2
votes
0answers
25 views

How to add “Duplicate” to Windows 8/10 context menu

I work between Mac and Windows all day mostly with Creative Cloud products. One item I really miss on windows it the simple 'duplicate' command. Context or CMD+D on a Mac. I know I can copy and ...
3
votes
1answer
59 views

DOS Find duplicate files between two disk drives

I have two drives, lets say driveA (F:) and driveB (G:). I had once copied all of the contents of driveB into driveA. But after that the driveB has some new files and folders added to it. I would like ...
1
vote
1answer
31 views

Highlight Duplicate Rows (not cells)

I need to highlight duplicate rows in my Excel 2013 sheet. I can highlight duplicate cell values within rows, using "Highlight --> Duplicate" method, but what i'm trying to do is to highlight the rows ...
1
vote
0answers
30 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
20 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
45 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
58 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
85 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
30 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
143 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
152 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
106 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
527 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 ...
3
votes
1answer
1k 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
105 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
130 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
139 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
77 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
1k 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
24 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
34 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
140 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
96 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
67 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
53 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
287 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
402 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
123 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
39 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 ...
-1
votes
1answer
529 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
506 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
2k 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
577 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
2k 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
121 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
1k 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
85 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
139 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
91 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, ...