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

learn more… | top users | synonyms

0
votes
2answers
23 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 ...
-2
votes
0answers
24 views

Win 7. Use the contents of manually updated .xls to create a batch file that deletes files in folder to match spreadsheet?

Win 7.Use the contents of manually updated .xls to create a batch file that deletes files in folder to match spreadsheet? Hi. I have a folder that has a number of subfolders. Each sub contains lots ...
0
votes
1answer
50 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
14 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
38 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
21 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
59 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
53 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
22 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
32 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
1answer
41 views

Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries. I do not want to simply remove ...
0
votes
2answers
107 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 ...
0
votes
1answer
134 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
34 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
72 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
118 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
49 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 ...
1
vote
0answers
53 views

What program/app is renaming files with “yyyy-mm-dd hh.mm.ss” as the filename?

My pictures folder has a bunch of renamed pictures and movies, with many duplicates all the sudden. All the renamed files are named with this date/time format: yyyy-mm-dd hh.mm.ss. Original files ...
0
votes
0answers
17 views

Need to find duplicate names in a column

Need to find duplicate names in a column but the name have been added with differnet formats. Some names have been added "first name then last name " and others have been added "last name, first ...
0
votes
0answers
11 views

Remove duplicated images with the shell [duplicate]

I have a folder with osme images. Each of them has a different name but some of them are duplicate. What is the best way to delete the duplicates? I have to do it sistematically so I need some shell ...
0
votes
0answers
22 views

directory comparsion for files with the same content but different name and directory

I always got frightened when had to delete some backups. I'm never sure if all of files in the backup still exist in oryginal folders (perhaps some of them was accidentally deleted or corupted). The ...
0
votes
0answers
100 views

Compare multiple columns across sheets in Excel and find full and partial duplicate rows

I have a workbook with multiple sheets (number of sheets will increase and decrease but for sake of example let us assume it is 101). 100 sheets have data in 2 columns A and B (both with header row). ...
0
votes
1answer
44 views

Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted. The value 7264 in column B has duplicates so ...
1
vote
1answer
285 views

How a count of values which have more than 1 occurance in a column

In cell B5 I have a formula: =SUMPRODUCT((A2:A10<>"")/COUNTIF(A2:A10,A2:A10&"")-(COUNTIF(A2:A10,A2:A10&"")=1)) If column A has the data as shown below, the formula returns the ...
-1
votes
1answer
275 views

Duplicate video finder? [duplicate]

Is there such a thing as a duplicate video finder that will look for duplicates based on video/audio comparisons of files rather than just the file size?
2
votes
3answers
552 views

How do I sort out duplicates using a formula in excel? Listing the unique values in adjacent cells. Without using VBA?

Pretty often I want to pick unique values from a table and list them in another, mostly to make statistics or summaries. A child can do this manually, shouldn't be too hard a task for my computer to ...
1
vote
1answer
62 views

Duplicate items in windows 8 taskbar

Ok so, I've done the stupid thing of deleting my desktop folder so I could symlink it somewhere else. That caused a lot of issues and one of them is that the items in the taskbar have duplicates (or ...
0
votes
4answers
92 views

How would I exactly duplicate a USB drive?

I have a standard USB flash drive that I have partitioned and formatted and organized and done quite a lot of things to. I was hoping to create another copy of that drive, with partitions and ...
0
votes
2answers
824 views

How can I find duplicate substring text between two colums in Excel?

I have two columns of data. Column 1 contains a list of email address domains such as gmail.com, yahoo.com, mydomain.edu, myotherdomain.org etc. The second column contains a list of complete email ...
0
votes
0answers
28 views

Remove visually similar images from folder [duplicate]

I need a free application/tool to remove visually similar images from folder. Most of the tools available are free only for demo version(i.e limited to few results)Found this ,but its script/code.
-2
votes
1answer
250 views

Batch file delete duplicates, nested once deep

Yes, I did see: Delete duplicate files with Windows batch file But I was unable to modify it to check each subfolder of that I specify, I have: del "c:\...\Pictures\*\*-001.*" But it doesn't like ...
0
votes
1answer
3k views

Excel: Find matching values in 2 columns. [duplicate]

I have a spreadsheet with 2 columns. These columns have telephone numbers in them. I need a list of where the same telephone numbers exists in both columns. These need to be listed in column C as the ...
0
votes
2answers
480 views

How do I duplicate pages within PDF files automatically?

I have a lot of PDF files with 1 to 4 pages each. I need a solution which automatically generates a new file for each of these files. The new files should contain the content of the original files ...
0
votes
0answers
35 views

easy way to eliminate duplicate files of different types

When I used iTunes a while back it converted all my .WMAs to m4v. I got out of iTunes and now I have some duplicates. Not every WMA has a duplicate because some were created after I stopped iTunes ...
-2
votes
2answers
183 views

I seem to have multiple copies all over my desktop & external hard drive? [closed]

I have multiple copies of all my music and photos duplicated in all related program files, plus in my documents, which is seen in several locations on the internal hard drive & my external HD. ...
0
votes
1answer
364 views

remove duplicates command prompt on mac

I have looked for various free software to remove duplicate on my mac but could not find a good one. I have finally settled on command prompt to delete duplicate files but I can't get it to work ...
-2
votes
1answer
44 views

How to remove duplicated images automatically? [duplicate]

My photos folder contains lots of dupblicated photos. How can I get rid of duplicated copies?
1
vote
2answers
2k views

Excel: if duplicate cell value found in another column then highlight green

Can someone help me, I'm not sure what formula to use. I have highlighted the cell in the picture to show an example of what I mean. What I want to do is highlight the cell in column A where the ...
0
votes
2answers
235 views

Duplicate SCSI HHD to SATA SSD

I got the Cavalry Dual Bay SATA Hard Drive Duplicator Docking Station and it works great when I Clone/Duplicate SATA Hard Drives but I have a couple of SCSI HHDs that I want to Clone/Duplicate but the ...
0
votes
1answer
537 views

Combine duplicates in Excel, sum some columns and weighted average the others

This question refers to an existing subjexct on our site. I need a variation on this solution. I have a spreadsheet with 8 data columns. The number of records can vary from a few hundred to about ...
3
votes
2answers
3k views

Can I set Windows default second-monitor behaviour to “Extend these displays”?

I travel to multiple offices (and multiple desks in those offices), and whenever possible I plug an external monitor into my laptop. Whenever I plug in a monitor I haven't used before, Windows ...
0
votes
1answer
34 views

Removind same *.tar.gz archives

I have crontab event archives to .tar.gz some folder every N hours. Finally I have collection of .tar.gz files. Now I want remove duplicating archives (created while target files stays unchanged) How ...
2
votes
2answers
50 views

Vista loads two logon screens at system boot

I recently reformatted my hard drive and reinstalled Vista as the operating system. Now when I boot the machine, two logon prompts are shown. I noticed as I would start typing my password and then ...
3
votes
2answers
177 views

how can I sort duplicate values in excel without repeated it sequence

i want the excel sort the values A to Z first then take the duplicate values to sort it again below A to Z like the following: if i have the values a,c,b,e,d,a,c when i sort it a to z it's look like ...
0
votes
1answer
688 views

Excel 2007: How do I make a formula to automatically remove (partially) duplicate rows of data?

I am wanting to automatically delete any rows of data A#:C# which have duplicate dataset combinations in columns A (alphabetical text) AND B (numeric text) so that every row has a unique combination ...
0
votes
1answer
320 views

Rows disappear when removing duplicates libreoffice

I pasted a lot of data in Column A. Then I removed duplicates: Data > Filter > Standard Filter > More Options > No Duplication Now I'm stuck in row 2632, i.e. I canĀ“t scroll up to rows ...
-1
votes
1answer
337 views

Highlighting duplicate column-pair and counting the rows Excel

Given the data below, the column-pair with the same values for at least 4 consecutive rows should be highlighted. Here's an image for better visualization: 2 2 3 4 3 4 3 4 3 4 2 3 1 2 ...
0
votes
3answers
797 views

Highlighting duplicate column-pairs in Excel

Example, this is the data in Excel: 1 2 2 2 3 4 3 4 3 3 2 2 2 2 1 2 The rows which have consecutive duplicate column-pair values (in bold font) should be highlighted: 1 2 2 2 3 4 3 4 3 3 2 2 2 2 1 ...
0
votes
0answers
237 views

Tuneup Media plugin for iTunes?

Do anyone have any experience with Tuneup Media plugin for iTunes? I have thousands of MP3 files and it is really messy all over place. Some in drive E and F. There are a lot of duplicates files in ...
0
votes
0answers
329 views

How to delete duplicate recursively in Chrome browser's bookmarks?

How to delete duplicate recursively in Chrome browser's bookmarks? I'm guessing because of syncing glitches it end up getting duplicate entries in various places.