I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.
I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.
You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)
I started out with the two previous posts about macros (post 1, post 2) that move rows into columns, but I'm having a little trouble getting it to work for what I need. First, I'm trying to do a data merge into Word, but in order to get the data merge to work/look the way I want it to, I need the XLS data to be in columns.
I'm attaching an example file that has one worksheet of the sample data (though my "real" data has about 300 rows) and the other worksheet is an example of the outcome I need.
Is there anyway I can do what I need? Exporting into another file or another worksheet within this file would be fine.
Thanks in advance.
Read other 11 answers
at the top right of your post, click on the Edit button. At the top of the page you will see a check box marked Delete. Check it and then click the Delete Now button!
Been using Glary's Utilities 3 to clean things up. When I ran its "Duplicate" cleaner, there were many duplicates with iTunes and my pictures. My problem is that I don't know which to delete and which to keep. Here are screen shots to give you an idea of what the duplicate scan showed (BTW, there are many other areas where there are a mess of duplicates,but to keep things simple-I hope, I've only shown those duplicates that may take up a lot of space:
Flycaster mate cannot see any screenshots? so cannot comment.
Personally I am not that overly keen on add on software like Glary but it's your choice.
Is there a good free program or way of deleting duplicate music files, simply?
Thanks for any help!
Is there a good free program or way of deleting duplicate music files, simply?
Thanks for any help!
right click on the file and choose delete
Read other 4 answersHi there,
I told my buddy I wanted to reformat my computer. He went to do that by installing a new Windows 7 64 bit for me, but somehow, I now am operating on the new Windows 7 but my old Windows 7 still exist and is taking up enough space in my hard drive to annoy me
Can someone please let me know how I can delete the old Windows from my hard drive? I'm having to install all the old applications I used to have (Quickbooks, Photoshop etc) and it's eating up the hard drive space due to double applications.
Thanks for the help!
Hello Tony, and welcome to Seven Forums.
Sure thing. The tutorial below can help show you how to delete the Windows.old folder.
Windows.old Folder - Delete
Hope this helps,
Shawn
Hi! I use the free version of CCleaner to list duplicate files, many of which are dll or java script files along with a few dic files. Almost all of them in a group have the same name, size and creation date, but have different paths. Those paths share an initial path, but then differ to one or two different sub-folders.
So my question is this: which, if any, of the dupes can be deleted? In other words, if I retain the highest level of a file and delete the dupes in its sub-folder, am I asking for trouble?
Thank you very much: I'm glad I found your site!
Cheers...Steve
Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 10 Pro, 64 bit, Build 18362, Installed 20190829113902.000000-300
Processor: Intel(R) Core(TM) i7-6600U CPU @ 2.60GHz, Intel64 Family 6 Model 78 Stepping 3, CPU Count: 4
Total Physical RAM: 16 GB
Graphics Card: NVIDIA GeForce 930M
Hard Drives: C: 222 GB (38 GB Free);
[NB: I have 2 external hard drives, one for system backup and one on which all my photos are stored]
Motherboard: LENOVO 20FAS5WR00, ver SDK0J40697 WIN, s/n L1HF68P04J4
System: LENOVO, ver LENOVO - 1280, s/n PC0GCSCM
Antivirus: Windows Defender, Enabled and Updated
Leave them alone. DLL type files take up very little room and you run a VERY real risk of messing something up.
CCleaner is a fine program however do not use the registry cleaner part nor the part you are attempting to use.
Hi, Is there such a program as a free duplicate photo finder out there for download? I have a ton of duplicate photos on my hard drive and need to delete them. Thanks.
I am using WLM in W7 x 64 bit on my desktop. Recently several duplicate contacts have appeared in my contacts list.
I have tried to delete them by right clicking on the duplicate contact, but in every case the 'delete contact' is greyed out.
Can you please help ?
Hello mate now the first that comes to mind is that you run these if you haven't already
http://www.sevenforums.com/tutorials/1538-sfc-scannow-command-system-file-checker.html
http://www.sevenforums.com/tutorials/433-disk-check.html < if necessary include the /f and /r in the command line as per Option2
if those do not fix the problem then a scan with these - just to eliminate anything untoward that may be lurking
http://www.superantispyware.com/
http://www.malwarebytes.org/products/malwarebytes_free/
http://www.bleepingcomputer.com/download/adwcleaner/
ADW download from bleeping computer delete any rubbish found with the malware scans
(with ADW if you are running Kaspersky it will throw it up as malware just override Kaspersky by ignoring it or disabling it for the duration of the scan)
I've created a folder with shortcuts to all my songs; about 3,000 in total.
The problem is that it's created duplicate shortcuts for most songs:
How would I go about deleting the duplicates? The duplicates share the same name, just with ".lnk" at the end.
I've tried using the following AutoHotkey scripts but none of these worked, they ended up deleting every file in the folder.
FileDelete, F:\Music\myshortcuts\*lnk*.*
FileDelete, F:\Music\myshortcuts\*.lnk
FileDelete, F:\Music\myshortcuts\*lnk*
Any suggestions? Thanks.
I think I downloaded a .reg file from internet that created double system folders in my computer but I can't remember. They seem to be an extra music, videos, documents, pictures and downloads folder but I cannot put any files in the folder. Anyone know how to delete them? There's also a strange name in address bar when I open one of the folders. Also, when I click start and then click a folder liek videos folder then nothing happens.
Hello and welcome to TenForums
There is a tutorial that describes how you can delete or restore these folders here:
This PC 'Folders' - Add or Remove in Windows 10
Might be worth trying these methods to see if you can restore them.
Hi all, sorry if this is not in the right category (it kind of mixes email and applications).
I work IT for a local school and we're moving everyone's email from Rackspace email to Gmail. The way we have everyone copying old emails over is to have them setup both accounts in Apple's Mail 6.5 program (all the teachers have Macbooks) and drag and drop from one account to the other.
Here's my concern, we have several teachers who've wound up with duplicate emails in their new Gmail inboxes. Is there a quick way to get rid of the duplicates without manually having to go through each email. Is there some trick on Gmail or a usable script on Mail 6.5 (all laptops on Mountain Lion or Snow Leopard) that will help out? Or perhaps some third party program or service? Any advice would be great. Thanks.
I reinstalled XP Pro to another directory and now I have two installed. How do I delete the original operating system in the Windows folder. It tells me it is a system folder and will not let me delete it.
Thanks
Donald Spinks
You should be able to delete the folder unless some of your programs are using it.
If you are using a FAT32 file system use a Dos boot disk to access the command prompt and delete the folder from there.
If you are using NTFS then use the recovery console to delete it.
My ie "favorites" bookmarks are endlessly duplicating and cannot be deleted. Is there any way to save my bookmarks and get rid of the copies?
Click start, run, type %userprofile%\Favorites and press enter. See what's going on in there with Windows Explorer.
Read other 13 answersHi so I was changing my password on my hotmail account.( i know old school ) My administrator account windows is linked with my homail account. I changed the password on my mobile device. And when i turn my laptop I wasn't able to login. Therefore
I opened another account with the changed password.
Now whenever I turn on my laptop there's two administrator accounts. I'm not able to delete one of them. Please help
I wonder can anyone recommend a free program out there that can find duplicate files, pictures etc on a computer? I found some but I am not sure if they are SpyFree and VirusFree.
Hi mamma,You can try this freeware :http://www.softpedia.com/get/System/File-M...le-Finder.shtml
Read other 5 answersOk another challenge.. I wish I could do this myself, but I struggle with the code.
Is there a way to have a macro check the line below it, and if it is a duplicate row, delete it
I have rows of data with duplicate cells in each row.
I do not want to delete any rows.
I want to delete only duplicate cells in each row.
There are many ways to delete dups in columns. I do not want to delete rows. I do not want to delete rows if dups appear in the row. I want to delete the dups going across the sheet from left to right, row by row, going down the sheet from top to bottom.
For example, I five rows...
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
I want to delete the duplicate cells in each row. I want to end up with the following...
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
Just to clarify, if a cell is repeated in a row, one unique cell should be left in the row in which the repeated cell appears. I only want to delete repeated cells in the rows in which the repeated terms appear, leaving only one unique where the repeated cells appear. If the word "cat" appears five times in row 2 and three times in row 3, after the macro is run, the word "cat" should appear once in row 2 and once in row 3.
In some cells, spaces do appear because in some cells, the cells contain a short phrase (dog bone) rather than just... Read more
My PC was recently updates to WIN 7 and folders from my old XP were imported from backup. Now I have duplicates all over the place. Only my wife and I use this pc. Can anyone help me try and restore some sembelance of order to the folders/files.?
Several of us use Puran Utilities, it has that function. Use caution with any and all downloads to avoid junk!
http://www.puransoftware.com/Puran-Utilities.html
I want to free up space on my hard drive, so I ran a duplicate files finder.
I have several duplicate copies of (large) driver files. I would think that I only need one. One of the folders with drivers is c:\drivers. I use Windows 7, so I imagine I need that folder. I also have folders with some duplicate drivers: \documents\double driver backup and \dell\drivers.
Do I need those last two?
You should keep the c:\drivers. You can delete the others, but if you need to delete because you are running low on hard drive space you really need to install a larger hard drive. Considering the price of hard drives, now, there is no reason to have to delete, etc, because of drive space.
Read other 4 answersRunning Windows XP Pro on several computers here. Only *one* of them has this problem:
Everytime I create a desktop icon, the computer adds a second identical icon on the desktop. The second icon can't be deleted. When I try to delete it, I get the error message "Cannot read from the source file or disk."
What gives? Any help appreciated. Thanx.
I'm wondering if a simple scan disk won't fix the problem. ScanDisk checks your hard drive for errors and then fixes them.
I ran CCleaner and it found lots of duplicate files on my laptop. Should i delete the duplicates?
Hi, That is one of the weak part of Windows - and other software. Each software creates its own folder and it normally uses that folder to run. Windows should be smart enough to store common files in only one spot but it can't work this out ! You can delete them BUT please note them where they are because you may have restore them back for other programs. My suggestion: keep them, few hundred megabytes now are just a piece of cake. Regards.
Read other 5 answersI use SkyDrive as my cloud storage and have 5GB of files in it.
But I want it to be IN THE CLOUD and hidden, not accesible to everyone using my laptop and not duplicate copies of the files in my hard disk (actually triplicate copies).
For example, let's say my 3GB music collection. I keep a copy in my hard disk within "My Music", a copy in the cloud in Skydrive, but now I have a third copy in my hard disk within the Skydrive folder, which I didn't want and I wasn't asked about.
Microsoft assumed I want this third copy for some reason and downloaded everything automatically to this Skydrive folder. Great.
So, the first thing I do is uninstalling Skydrive, if I want to upload something I do it via browser, but the folder and copy of my files is still there.
My question is, can I delete those files, my music collection and so on without deleting at the same time the copy in the cloud? I mean, if I delete them here they will be deleted in the cloud too?
Thanks in advance.
Copied this from the skydrive FAQ.
What does the SkyDrive folder do?
When you install the SkyDrive desktop app for Windows, a copy of your SkyDrive is downloaded to your PC and put in theSkyDrive folder. This folder is kept in sync with SkyDrive. If you add, change, or delete a file or folder on SkyDrive.com, the file or folder is added, changed, or deleted in your SkyDrive folder and vice versa.
For various reasons, I find that a large number of my music tracks in iTunes are duplicated. I wanted to delete these but don't relish trawling through about 3000+ tracks in the "My Music" section and deleting the unwanted ones individually! Is there any way (duplicate tracks deletion program, etc.) that I can use to help me to do this? Once I have rid my system of these I would then like to transfer most of the remainder to Playlists, which I could easily arrange. Thanks.
Have been told about a small free program called GizmoTrim which cleared out all my duplicate tracks very quickly and successfully - highly recommended! (Marking solved)
I have had to use WinXP's "File Settings & transfer Wizard" several times over the last few years, and every single time I do so, all the messages in Outlook Express get duplicated.
So now I have hundreds (maybe thousands) of duplicated messages.
And I only need just one copy. Really, one is enough.
I've Googled quite a bit and cannot find a free/trial/shareware utility that will do this. It seems like it should be a fairly common problem, but for some reason I am unable to find a utility to fix the problem.
Any suggestions would be appreciated & thanks in advance,
George
get all available office updates here
Also if you are getting your emails from a private server disable your AV firewall softwares mail scanning OFF. These softwares cause the outlook express/outlook to send multiple signals to the server and receive tons of duplicates if they are not configured right or have a competability problem with the server. Turn email scanning off.
Does anyone have a macro that will delete row that have duplicate cells in same row other columns?
Hi
Are you looking to delete rows that have duplicate data but the duplicate data is in different columns?
Can you give a small example?
If the duplicate values are in the same column then you can use the 'remove duplicates' tool.
Select the rows/columns then go to DATA and you should see the REMOVE DUPLICATES tool.
James
i have several gigabites of music files most in mp3 format.is there a software or tool to search for duplicates and delete them, or i can delete them? free software preferred.
Is there a program or a way to locate and delete duplicate files? I seem to have a lot of duplicates and my hard disk is getting full.
I began receiving messages about corrupted files in XP and so tried to repair option to reinstall the corrupted files, but somehow ended up completely reinstalling into a second directory.
Both directories are on my C drive. One, the original, is still the same. All software installed and working the same as before my attempt. The second, Windows.0, is XP with nothing installed, fresh condition.
As this isn't an upgrade from another windows, I'm don't know how to get rid of this second windows.
Also, everytime I reboot my computer, it asks me which windows I want to use.
Not to mention the wasted disk space...
How can I get rid of these!!??
Hi J-BO and welcome to TSF.
Try This
Hello,
I have a hard drive that has all sorts of archives of archives in it. So many, that I think I have duplicates of many files. They are not compressed or anything.
I would like a program to go through the HD and pick out the duplicates and preferrably, automatically delete the oldest one, or prompt me.
Is there a good program out there that does this?
Thanks!
Hello,maybe this will helps you
Auslogics Duplicate File Finder Helps Declutter Your Disks
and you can try something from google search list
http://www.google.com/search?hl=en&s...licate&aqi=g10
Logfile of HijackThis v1.99.1
Scan saved at 4:58:54 PM, on 04/19/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16414)
Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\ctfmon.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\Creative\SBLive\Creative Diagnostics 2.0\DIAGENT.EXE
C:\Program Files\Hp\HP Software Update\HPWuSchd2.exe
C:\Program Files\Linksys Wireless-G USB Wireless Network Monitor\InfoMyCa.exe
C:\PROGRA~1\Grisoft\AVG7\avgcc.exe
C:\Program Files\QuickTime\qttask.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\Messenger\msmsgs.exe
C:\Program Files\AIM+\AIM+.exe
C:\Program Files\Siber Systems\AI RoboForm\RoboTaskBarIcon.exe
C:\Program Files\AIM\aim.exe
C:\Program Files\Google\GoogleToolbarNotifier\1.2.1128.5462\GoogleToolbarNotifier.exe
C:\WINDOWS\system32\devldr32.exe
C:\Program Files\Southwest Airlines\Ding\Ding.exe
C:\Program Files\Sony\Sony Picture Utility\VolumeWatcher\SPUVolumeWatcher.exe
C:\PROGRA~1\Grisoft\AVG7\avgamsvr.exe
C:\PROGRA~1\Grisoft\AVG7\avgupsvc.exe
C:\PROGRA~1\Grisoft\AVG7\avgemc.exe
C:\WINDOWS\System32\CTsvcCDA.EXE
C:\WINDOWS\wanmpsvc.exe
C:\WINDOWS\System32\MsPMSPSv.exe
C:\Program Files\Linksys Wireless-G USB Wireless Network Monitor\WLService.exe
C:\Program Files\Linksys Wireless-G USB... Read more
I am wondering whether anyone knows of a good utility that can search through your address book in Outlook Express 6 and delete duplicate entries?
Many thanks in advance...
Please do not start more than one thread for the same problem.
Closing duplicate.
Please continue here:
http://forums.techguy.org/showthread.php?t=499901
Hi All,
I have a few macros in Normal.dot including some which load a new letter with different Headers and Footers for business letters and personal letters.
I have assigned buttons for the macros BUS HOM BEN
When I click "New" in the menu I get a new page using the Normal.dot template showing my Macros.
BUS - HOM - BEN
Now, if I click the button for the "Business Macro" = BUS, I get the correct new letter with Business header, but now it has duplicate Macros as in....
BUS - HOM - BEN - BUS - HOM - BEN
I go to the Customize menu and in the Macro list it shows them duplicated, no surprise there.
How can I delete the excess Macros?
Thanks
I found many macro showing how to find duplicate values and then delete the row. But I need a macro to delete all the duplicate values from columns A to E & G without deleting the rows. Like from example A to example B on the attached Excel spreadsheet. Your help will be greatly appreciated.
I have a list of 39525 emails in column A and a list of 19909 emails in column B. If there is the same email in column A and B, I need the duplicate removed from column B and stay in column A. Please help Thanks!
I have over 50 virtual networking adapters in device manager, I have posted this question in many forums, and still cannot get rid of these pesky unused extra adapters. I know they have been created by using Virtualbox, and by creating many virtual machines and updating virtualbox. Unfortunately, I have tried uninstalling virtualbox and the drivers all remain in devicemanager. DeviceMgmt also does not allow me to uninstall or delete the adapters, (When I do they just stay there, even after rebooting.)
I most likely have to go into the registry and delete them, but they are in so many different places there, I need to know the correct place to delete them.
I have a bet that this is the forum where I will get the answer for this even though I have posted in virtualbox forums, technet, MSDN, superuser, serverfault, and stackoverflow.
Hi try the 2nd post in this link : networking - Unable to uninstall virtualbox network drivers - Super User
Read other 8 answersI'm running Windows XP on my laptop and my hard drive is almost full. I have been trying to delete files, but everytime I try to delete a file, a duplicate file is created. How can I delete files permanently without creating duplicate files?
When you right-click the file and select Delete, a copy of the file is made?
I am getting rid of my wifes old iphone and I have transferred all of the pictures and videos from it to this computer. The problem is I think I have tons of duplicates now since I am pretty sure I had transferred them all a while ago. How can I check the computer for duplicate pictures and whats the fastest way to delete the duplicates? They are in different places on the computer but the most recent I put in a folder on the desktop. I would hate to delete a picture since 99% of them are of my daughter from when she was born to now basically.
Hello Nikeman123
I think DoubleKiller - find and remove duplicate files (Big Bang enterprises) is what you're looking for. Small yet effective.
I am wondering whether anyone knows of a good utility that can search through your address book in Outlook Express 6 and delete duplicate entries?
Many thanks in advance...
Hi jeremywms
Can't speak for any of them, here are a few I found:
http://www.snapfiles.com/downloadfind.php?action=s&st=remove+duplicate+e-mail+accounts
After upgrading from XP to Windows 7 (on a new computer) and making several abortive attempts to transfer my Outlook Express Folders and Addresses to Outlook, I have succeeded in making thousands of duplicates before finally "getting it right." Is there an easy way to globally delete duplicates rather than doing them one at a time?
I suppose I could delete all the folders and addresses and start over with the successful transfer method. If I did this how would the deletion process work? The latter method kind of scares me because I have over 14 years of data invoved.
Thanks for any suggestions.
Quote: Originally Posted by midjack
After upgrading from XP to Windows 7 (on a new computer) and making several abortive attempts to transfer my Outlook Express Folders and Addresses to Outlook, I have succeeded in making thousands of duplicates before finally "getting it right." Is there an easy way to globally delete duplicates rather than doing them one at a time?
I suppose I could delete all the folders and addresses and start over with the successful transfer method. If I did this how would the deletion process work? The latter method kind of scares me because I have over 14 years of data invoved.
Thanks for any suggestions.
What I would do is export the addresses from Outlook Express to a Excel spreadsheet. Check them and make sure it looks complete. Go into your Outlook Address Book. You can hold down Shift and Page Down and it will highlight all adresses. When they are all highlighted, just hit delete. That should get rid of them. You can then import the spreadsheet with the correct Address Book and you should be in shape. It shouldn't take too long.
I have an extremely large file and I need to match off values within rows that are equal to each other and delete the rows with matching values.
For e.g. Column D and Column H have the same numerical value
so the row needs to be deleted
Please help!
I forgot to mention that I do not want the Macro to include blanks
Only if there are actual numerical values in the cells of Column D and Column H
