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

learn more… | top users | synonyms

0
votes
2answers
28 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
15 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
20 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
18 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 ...
0
votes
1answer
62 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
25 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
44 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
41 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
95 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
25 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
106 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
25 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
73 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
163 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
39 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
47 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
145 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
288 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
2k 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
61 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
131 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
256 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
52 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
69 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
18 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
26 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
107 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
53 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
524 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
365 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
993 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
67 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
105 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
1k 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
29 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
303 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
10k 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
674 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 ...
-2
votes
2answers
205 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
446 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
45 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
3k 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
304 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
838 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
227 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
765 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 ...