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

learn more… | top users | synonyms

0
votes
1answer
27 views

How to identify 2 duplicate cells next to each other only in Excel

if someone can help me with this question please. How to identify duplicate cells next to each other not in adjacent column but adjacent row like my sample below. Thank you. 4/30/2016 5/12/2016 4/5/...
0
votes
1answer
20 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
30 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
23 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: ...
0
votes
1answer
39 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 ...
0
votes
0answers
29 views

Find Duplicate Files Between HDD (for ex: Total Size:500Gbs) AND HDD Image only Files Hash(3mb)

Any way to find duplicate files between a files/folder group and image hard disk (files content hash database)
1
vote
0answers
27 views

How to batch delete files based on their checksum matching an existing list of checksums

I'm looking for a means of deleting files based on their checksum matching a list of previously seen checksums in a text file or some other list. The context is a large photo organization project ...
0
votes
0answers
16 views

Outlook email duplication

I am currently trying to work on sorting out an email issue in Outlook for a customer and I'm not too sure of a solution. In Outlook on this specific PC I am on the emails keep getting duplicated but ...
0
votes
0answers
23 views

Duplicate and retransmission

Please help me understand why the receiver keeps sending duplicate acknowledgements, yet the senders keeps sending old packet sequence (re-transmitting of old packet seq) in the below capture: Please ...
0
votes
0answers
25 views

How to duplicate the center/front channel of surround sound to a 2nd (rear) speaker?

We have a 5.1 surround sound system for our TV. My family watches TV while I'm in the back (kitchen) cooking dinner. I can see the 60" TV just fine, but I can't hear the center/front speaker very ...
1
vote
2answers
43 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
58 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 ...
0
votes
1answer
13 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
66 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
29 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
46 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
45 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
50 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
79 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
142 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
1k 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
29 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
78 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
38 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
32 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
22 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
51 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
65 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
174 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
38 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 ...
1
vote
1answer
204 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
176 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
860 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
3k 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
175 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
181 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
187 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 ...
1
vote
1answer
2k 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
1answer
167 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
114 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
87 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
74 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
495 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
583 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
20 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
160 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
40 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
643 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 ...
1
vote
1answer
987 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 ...