Over 1 million tech questions and answers.

how to find and delete duplicate images/videos?

Q: how to find and delete duplicate images/videos?

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.

RELEVANCY SCORE 200
Preferred Solution: how to find and delete duplicate images/videos?

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.)

A: how to find and delete duplicate images/videos?

Hello Nikeman123

I think DoubleKiller - find and remove duplicate files (Big Bang enterprises) is what you're looking for. Small yet effective.

Read other 19 answers
RELEVANCY SCORE 118.4

I have scads of images and videos, etc, with a lot of duplicates. Some of them are necessary: I have two external drives with backups of important family stuff, travel, etc. (plus backed up on Google Drive.) Yeah, I'm paranoid about losing priceless stuff.....is there a good tool/online service/something that I can use to ferret out all the duplicates and safely delete what I don't need? I recently saw a product that promised to do that but it's $50 and before trying that I wanted to post here first. Thanks!
 

Read other answers
RELEVANCY SCORE 76

Well I have a quandry. We have all of our digital pictures on our server. This spans back about 4 years now and each month we have a new directory.

As you may be able to tell we have quite a collection - over 6,000 files (including all of my scanned in old pictures that are over 25 years old)

The biggest problem I have is my WIFE has decided that the pictures (that we take with a large resolution for keeping) then resizes them and renames them IN THE SAME DIRECTORY! It drives me nuts because after she sends them out she does not delete them so now though I esitmate we have about 6,000 files theres actually about 8,000 pictures in the different subfolders.

What I need to know is if there is any program out there that will determine duplicate picture content. I would perfer it to find it on subfolders as well but if it only checks one directory that would be fine as well.

I am thinking this is a longshot but figured I would ask as for me to do this manually will be a BIG project and alot of time on my part.

Actually I am starting to think about making the directory and subdirs read only to her
 

A:Find duplicate images?

Read other 10 answers
RELEVANCY SCORE 70.4

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.

A:How to find & delete duplicate files

Hi mamma,You can try this freeware :http://www.softpedia.com/get/System/File-M...le-Finder.shtml

Read other 5 answers
RELEVANCY SCORE 68.8

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!
 

A:Macro to find duplicate values within same row and delete that row if they match

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
 

Read other 3 answers
RELEVANCY SCORE 55.6

Over the years I've taken massive amounts of photos that translate to thousands of files. I've also moved the files around quite a bit creating multiple copies of the same image. Now I want to create a centralized copy of all the images but I want to take out any of the duplicate images. Standard copy/replace doesn't work since some images with the same filename aren't the same image.

Is there anyway to delete the duplicate images? I'm thinking of some kind of checksum for each image and running it against every other image in the set. Thanks!

A:Removing Duplicate Images?

I did this on my other PC which I don't have access to at the mo......but I think Picasa has a utility to do it, free download from google.

Read other 4 answers
RELEVANCY SCORE 53.6

I suddenly lost my start menu. After trying several failed fixes I ended up creating a new user. I downloaded my pictures folder to an external drive and attempted to upload them into the new user pictures folder using Teracopy. Teracopy is now stuck at 97%. I can stop Teracopy but I need to add the missing (but unknown) last 3% of images to the folder. How can I do this by over copying the folder without creating duplicates?
If I knew which images, and videos, are missing I could just copy them to the new folder, but there is no list of missing images. So, I want to copy the images over again but have an option to skip all possible duplicates.

Help would be great

Abel

A:How to prevent duplicate images after start menu crash

Hello, welcome to tenforums.

WinMerge comes to mind to identify the differences in your folders.
WinMerge download | SourceForge.net
Older program, but still works as far as I can see..

You might wish to run chkdsk to verify your disks to see if there's an underlying cause for your copy failure and even - perhaps- your start menu failure, although that could be for other reasons too of course.

E.g.
Win key + X, click command prompt (admin)
chkdsk C:\ /F
for drive C etc.

To help recover from future failures and problems in Win 10, which is relatively immature, if you haven't done so, set up a daily scheduled task to set a restore point, and enable System Restore which is off by default in Win 10, oddly enough.

Regularly updated 3rd party disk imaging is a fantastic way to secure your system, your data, and your sanity, allowing recovery to a previously working state in, say, 20 mins or less without technical help. E.g. Macrium Reflect (free) + boot disk + external storage medium. Really essential. Others: Veeam Endpoint backup, Aomei Backupper...

Read other 0 answers
RELEVANCY SCORE 52.8

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.
 

A:XLS Macro to move data to columns, delete empty rows, delete duplicate columns

Read other 11 answers
RELEVANCY SCORE 51.6

hi im using windows xp proff and im using a ati radeon x800 series graphics card i started to have a problem where if i restart my computer it will either give me a blue screen or i will just see a black screen and not do anything till i manualy turn it on and off again but if i start my computer normal (no restart) it works ok, then i started to get an error where my catalyst control center was erroring and stopping working and now i cant view any images in windows or run any music.
I have tried reinstalling my drivers and the control center and i am currently using an older version of my driver because they dont crash but im still getting errors on restart and i cant view images or listen to music please help

A:no images or videos

try a restore to a point before you installed the new drivers

Read other 2 answers
RELEVANCY SCORE 51.2

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:

A:Which duplicate(s) to delete?

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.

Read other 2 answers
RELEVANCY SCORE 51.2

duplicate - delete
 

A:duplicate-delete

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!
 

Read other 1 answers
RELEVANCY SCORE 51.2
RELEVANCY SCORE 51.2
RELEVANCY SCORE 50.8

im looking for a good program that can capture still images from video files, i downloaded and tried topaz moment but though it works sometimes other times its horrible, and when i pause the images i want i try to get ones that look pretty clear before i freeze the image so i mean im trying my hardest to find the right scenes that will get a good result also on there website they said its better then premiere i havent tried premiere for this but any know if thats true, or of one that personally works great for them ?
 

A:capturing still images from videos ?

Read other 6 answers
RELEVANCY SCORE 50.8

I recently connect my pc to my living room TV.
I have a ATI radeon 9800 and a Sony 29" flat screen TV.
Everything is fine, the connections, the sound, even the images of my desktop, I already saw images of some games, MP3 player, but, and this is the tricky part, I can't watch any of the videos.
The TV screen keeps blacked and I see the images of the player and the sound, but no images of the movie.
Could anybody help me with that?

Thanks

Almir Fuschini
Sao Paulo, Brazil
 

A:I see the images of my pc, but I can't watch videos

Hello! Welcome to TechSpot

Need to know the specs of your Pc.
Or fill out your user profile.
A shot in the dark, have you gone
into display properties?
Making sure all settings are correct?
G'Luck
 

Read other 6 answers
RELEVANCY SCORE 50.8

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 ?

A:Delete duplicate contacts in WLM

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)

Read other 1 answers
RELEVANCY SCORE 50.8

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.
 

A:Delete duplicate photos

Read other 9 answers
RELEVANCY SCORE 50.8

Is there a good free program or way of deleting duplicate music files, simply?

Thanks for any help!

A:Trying to Delete Duplicate MP3 files

right click on the file and choose delete

Read other 4 answers
RELEVANCY SCORE 50.8

Hi 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!

A:How Do I Delete An Old Duplicate Windows?

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

Read other 3 answers
RELEVANCY SCORE 50.8

Duplicate post, please delete

Read other answers
RELEVANCY SCORE 50.8

Is there a good free program or way of deleting duplicate music files, simply?

Thanks for any help!
 

A:Trying to Delete Duplicate MP3 files

Read other 10 answers
RELEVANCY SCORE 50.4

Doing research online I think this is a Registry Corruption problem, possibly with MIME. The help file with MS MSDN is very complicated and I am afraid I will just have to another F&amp;R. Which seems like all I do with this pc. I think it is time for a new pc-and a different brand.

After even more research it would appear that my javascript in the registry may be corrupted as well. Although my pc states it is active, and I have enabled it in Internet Options, every website I go to to check whether I have it comes back negative. Hulu will not function stating my javascript is being blocked but I can't find any program that is blocking it. I checked it out in my Registry and it is there but I can't tell if it is written correctly as I have no examples to go by.

I have a Dell Studio Desktop 540 pc with Windows 7 (upgrade from Vista). I had partitioned a section of my HDD and put Linux Mint 13 on there. Last Thursday I booted in to Linux and did an update on it. Afterwords I could not get back in to Windows OS on drive C. I ended up running a recovery disk that gave me the options to repair, recover, etc. I ran system tests which kept looping and I couldn't get in to either Windows or Linux. I put the Windows 7 Upgrade disk in and did an install where it kept my files in a Windows.old folder. However, this install is corrupt and I am having problems. My most pressing issue right now is that I am unable to fix the problem in where my browsers will not show imag... Read more

Read other answers
RELEVANCY SCORE 50.4

Yesterday about half of the images I encounter online load incorrectly. Bars of neon colors completely distort the images. I am having the same problem with streaming video. Bright pink, yellow, and green bars ruin the picture. It is the same in all browsers.
Also webpages are loading incorrectly with some sort of encoding error. All sites, including Google and bleepingcomputer occasionally load with lines of code and missing portions of the page. Often times links will not do anything when clicked.
I'm assuming the two problems are connected because they appeared at the same time. I'm not sure if it is a graphics card issue or an internet issue. Any help is appreciated.
Windows Vista 32-bit service pack 2
Firefox and Internet Explorer
Attatched is a screenshot of an image distorted with the strange colors.

A:Strange colors on images and videos

Does your desktop, other programs look fine?

Read other 19 answers
RELEVANCY SCORE 50.4

How Can I Steal Images And Videos From Mobile(MTP) To Pc when i conect any device to pc with USB Cable...
Thanks For Help
 

Read other answers
RELEVANCY SCORE 50.4

I know from View -> Options you can turn on the option to show thumbnails instead of icons but is there a way to only show thumbnails for photos and not videos?

Read other answers
RELEVANCY SCORE 50.4

A most interesting problem, and one that much internet scouring revealed is rather rare (or at least not widely discussed.)

http://i176.photobucket.com/albums/w...ganX/MPBug.jpg

and

http://i176.photobucket.com/albums/w...anX/mpbug2.jpg
(This is NOT a photobucket page. It is a video trailer, and the photobucket page on the opposite tab got superimposed onto it when I switched tabs.)

So basically, the screen gets whatever was behind it superimposed onto it. If I open up a game or some other program where it comes to the forefront of the screen and you must alt-tab out of it, the image there will be imposed where the videos are. (AKA, if the right side of my screen had a monkey and WMP was on the right side, a monkey would be superimposed on the WMP screen, and would stay there even as the video continues to play.) From then on, any image/folder etc you open will superimpose itself on the screen of WMP, and will not change as the video plays.

As you can see, this affects videos playing in firefox as well. This bug only being to happen when a resource heavy program, such as most games, is used. For some reason it does not affect youtube videos.

WMP must be closed and restarted in order to function properly. A complete computer restart is needed for firefox videos affected.

I have updated my drivers, checked for faulty codecs, reinstalled all my codecs I could find, uninstalled and reinstalled WMP, and still found no solution. I am certain something associate... Read more

Read other answers
RELEVANCY SCORE 50.4

When i try watching a video for example, on youtube, it wont show up at all, it just has a white background with a X. Not sure what exactly is wrong. What do i need to do to fix this problem?

Kind Regards,

ChubZ

A:Cant watch videos online, or see some images

Have you got the latest version of Adobe Flash Player installed?

Read other 3 answers
RELEVANCY SCORE 50.4

So, I was transfering some (lots) imgaes and videos from the internal storage of my android phone (Elephone P9000) to my SD card (that is in the phone at the moment) and after finishing this process I see that all those images and videos are gone, not in the internal storage nor the SD card.

I used cut and paste like normal I'm trying to use some softwares to try to recover all that but they can't even find my phone folder :/

Some prints:
http://prntscr.com/ftv8ze
http://prntscr.com/ftva4s
http://prntscr.com/ftv9qb
http://prntscr.com/ftvagj

If there's someone there that can help me I would be so grateful (sorry for bad english)
 

A:Somehow lots of images/videos disappeared, help me :(

UPDATE: wacthed this video -> and nothing happened
 

Read other 1 answers
RELEVANCY SCORE 50

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

A:Want to delete duplicate cells in a row, row by row, going down the sheet.

Read other 11 answers
RELEVANCY SCORE 50

Ok 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
 

A:Solved: Im sure it can be done.. Delete Duplicate Rows

Read other 16 answers
RELEVANCY SCORE 50

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.
 

A:Quick way to delete duplicate emails?

Read other 12 answers
RELEVANCY SCORE 50

I ran CCleaner and it found lots of duplicate files on my laptop. Should i delete the duplicates?

A:should i delete duplicate files on my computer?

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 answers
RELEVANCY SCORE 50

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
 

A:how do i delete duplicate operating systems

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.
 

Read other 1 answers
RELEVANCY SCORE 50

How can I create a query to delete duplicate records?
 

A:query to delete duplicate records

Read other 9 answers
RELEVANCY SCORE 50

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.

A:How to delete duplicate system folders?

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.

Read other 0 answers
RELEVANCY SCORE 50

please delete this is duplicate post.

Read other answers
RELEVANCY SCORE 50

Hi 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

Read other answers
RELEVANCY SCORE 50

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.

A:How to mass delete duplicate shortcuts?

Would *mp3.ink work?

Read other 2 answers
RELEVANCY SCORE 50

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?   

A:Duplicate ie favorites files - cannot delete

Click start, run, type %userprofile%\Favorites and press enter. See what's going on in there with Windows Explorer.

Read other 13 answers
RELEVANCY SCORE 50

Running 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.
 

A:Duplicate shortcuts on desktop ... can't delete

I'm wondering if a simple scan disk won't fix the problem. ScanDisk checks your hard drive for errors and then fixes them.
 

Read other 3 answers
RELEVANCY SCORE 50

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?

A:Duplicate drivers; which folder(s) can I delete?

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 answers
RELEVANCY SCORE 50

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.?

A:How to locate and delete duplicate folders

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

Read other 4 answers
RELEVANCY SCORE 50

i have an excel file and it's contain a huge number i need to find the duplicate and count the and then delete the duplicate one without losing the counting
 

A:how to find duplicate numbers

goto data
click on the column
remove duplicates - a pop-up tells you how many duplicates it finds and removes and how many unique values there are
198 - duplicates
112 unique values

write that down before saying
OK

is that ok
or did you need something else ?
if so can you be specific please
 

Read other 3 answers
RELEVANCY SCORE 50

Hi all,

I need to find duplicate data of company names in one column. The example looks like:

Column A
1. Postal
2. Postal Air
3. PostalAir
4. Energy resources ltd
5. Water us pty. ltd.
6. Plastic company

The duplication in the table is not always because of the same name, but it can be one date use the full company name and the other data is using the shortened name (for example, data in A1, A2 & A3 can be the same company) I have about 7,000 company names, please help me if anyone know any quicker way than doing this one by one, I use Excel 2007.

Thanks heaps!
 

A:To find duplicate records

its going to be difficult to do this, if the first three are identical as an example - I assume just looking at the fors 8 characters is not going to help as the same company may have a different 1st set of characters

you could use a Mid function to isolate a few characters and compare
like
Mid(a1, 1,6) - that takes the 1st 6 characters
now you could compare to the previous line
so you could put this is a column - starting at rows 2 copy down
=IF(OR((MID(A1,1,6)=MID(A2,1,6)),(MID(A2,1,6)=MID(A3,1,6))),1,0)
and where the 1st 6 characters match you will get a 1

which in your example should put a 1 against the 1st three

anything else in the data that can be compared ?

the above test the current cell with the previous row cell and also the next row cell if either match it will put a 1 - then you can eyeball the 1;s and decide if they actually match
if you have issues with spaces
so postal (space) service
and postal (nospace) service
you could use
=SUBSTITUTE(A1," ","")
to reove leading and training spaces
=TRIM(a1)
 

Read other 2 answers
RELEVANCY SCORE 49.6

Hi a month ago i installed windows 7 pro and i dont know when but i started noticing kinda of stripes barely noticeable on the right side of letters,then i noticed that whenever i right click on desktop and the box appears,the stripes appear on the right side of the box.

Then i Realize the suppose stripes is the true color of the image/video and that the rest on the screen have a kinda yellowish tint and for some reason on letter or boxes for 1cm or so the true color shows(without the tint)
leaving the impression of stripe or shadow.

I research the problem and could be my monitor(CRT 17?...lol...yeah i still use it)

so i need the help of you guys,here 3 images of my problem if you guys noticed the problem(look at right side of the box/letters)then i think its windows 7 if you guys dont noticed nothing at all then i fairly sure its my monitor since it usually this kinda of monitor problem dont transfer to print screen

here the images.

my specs are;

Atlhon x2 5000+
MB MSI
2GB ram
Geforce 8600GT 512MB

A:Weird yellowish tint on images,videos etc.

Seems to be your monitor.

Read other 8 answers
RELEVANCY SCORE 49.6

Hi

Any assistance would be appreciated - Even to stop my searching & decide that I cannot do this.

I am trying to add pictures of DVD covers next to my video's in Media Player 11 running on XP. At the moment it displays a default picture of hot air balloons next to each movie.

I have reverted back to showing them in list mode.

The movies are .avi.

Thanks

Mark
 

Read other answers